Skip to Content
Author's profile photo Sateesh Kumar Bukkisham

Show Trend Icon/Arrows in webi as per conditions

Hi All,

Business always interested in Trend/Arrows in tables instead of numbers .In 4.0 IPAD we can get this by writing some code.

we can use images and hyperlinks to get the same .But it needs some maintenance.

End Result

This blog gives you simple trick to show Trend/Arrows in your webi report as per condition.

We know that we can use ascii values in webi with CHAR() function.

CHAR(9660 ) – DOWN ARROW

CHAR(9650 ) – UP ARROW

CHAR(9679 ) – CIRCLE

> Insert new column to show Arrows/Icons

>Write alerter with sub alter to show Arrows/Icons with different colors as per condition.

>write condition : Sales Qty less 10

Format alerter as per requirement. In my case DOWN Arrow

Set color for ARROW :RED and width of arrow (you can change it by increasing font size and style as BOLD)

Now you need to create sub alert for the Sales Qty greater than 10

create alert

Format :

Display : =CHAR(9650)

Format : GREEN color

Now apply Alert in your blank column. That’s it 🙂

Similarly you can create Alerters for ICONS also.

You can get ascii char values for different shapes from here

Code Charts

Unicode character table

Note : You can use all the ascii codes. Neglect &# and use the number .Some of them may give (rectangle box) in rich client /rich internet mode ,but you’ll get the symbol in html mode (reading)

Assigned tags

      39 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      nice sateesh

      Author's profile photo Dharmaraja Subbaraja
      Dharmaraja Subbaraja

      I was looking for the same requirement. Thanks.

      Rajesh

      Author's profile photo Former Member
      Former Member

      Excellent Trick....

      Useful Document.

      Thanks for sharing.

      Regards,

      Chandrakanth

      Author's profile photo Former Member
      Former Member

      Hi Sathish,

      Thanks for sharing such a nice article

      Regards

      Syed

      Author's profile photo Anish Mahadik
      Anish Mahadik

      Hi Satish,

        Nice Document.Thanks for Sharing.

      Regards,

      Anish

      Author's profile photo Former Member
      Former Member

      Hi,

      Everyday i am knowing the new things in this blog, I personally feel this blog is very interesting 🙂 .

      I use to thing webI is little bit, But looking this blog I feel there r vast things need to be performed which I/we dont know even...Thnks for sharing.

      Regards,

      M

      Author's profile photo Former Member
      Former Member

      Superb... Thanks for sharing such an usefull info.. Keep post. 🙂

      Regards,

      Subbarao

      Author's profile photo Former Member
      Former Member

      also is it possible in BO 3.1 ?

      Author's profile photo Sateesh Kumar
      Sateesh Kumar
      Blog Post Author

      Hi Aaskar,

      It is possible in 3.X also.

      Author's profile photo Former Member
      Former Member

      Thanks Satish. It's a nice approach. Earlier I was using images with alerters.

      Author's profile photo Former Member
      Former Member

      Quite nice. awesome, thanks!

      Author's profile photo sampath guntha
      sampath guntha

      Hi Satish,

      Can we use all ascii codes in webi ? Because for some ascii codes we are having &# in front of the code that ascii codes.

      Thanks,

      G Sampath Kumar

      Author's profile photo Sateesh Kumar
      Sateesh Kumar
      Blog Post Author

      Hi sampath,

      You can use all the ascii codes. Neglect &# and use the number .Some of them may give (rectangle box) in rich client /rich internet mode ,but you'll get the symbol in html mode (reading)

      Author's profile photo WILLIAM MARCY
      WILLIAM MARCY

      Great Webi trick !

      You've been added to Webi 4.x tricks : summary for a better visibility. Keep posting !

      William

      Author's profile photo Sateesh Kumar
      Sateesh Kumar
      Blog Post Author

      Thank you William.

      Author's profile photo Former Member
      Former Member

      Excelent document, it's very usefull.

      Thanks a lot Sathish

      Author's profile photo Former Member
      Former Member

      Nice! Thanks for sharing.

      PS. the link to the ASCII chars is dead.

      This site provides a comprehensive list:

      http://www.unicode.org/charts/#symbols

      Here a converter for Hex to Dec

      http://www.binaryhexconverter.com/hex-to-decimal-converter

      Author's profile photo Sateesh Kumar
      Sateesh Kumar
      Blog Post Author

      Thank you very much for your valuable feedback and update Lynden Schwarzer

      Author's profile photo Former Member
      Former Member

      really useful

      Author's profile photo Former Member
      Former Member


      Hi Sathish,



      Excelent document, it's very usefull.Thanks for sharing such a nice article


      Regards

      sushma

      Author's profile photo Sateesh Kumar
      Sateesh Kumar
      Blog Post Author

      Thank you Sushma .I'm glad you find it usefull.

      Author's profile photo Sateesh Kumar
      Sateesh Kumar
      Blog Post Author

      Thanks to one and all.

      I have updated link for Ascii.

      Unicode character table

      Author's profile photo Former Member
      Former Member

      Hey Sateesh, I've been using this approach for couple of reports and the special character does not seem to export perfectly on to PDF document.

      For Example:

      I'm using Char(10004) for a Tick Mark on webi 4.1

      Capture.PNG

      But when exported to PDF file the Tick Marks seems to disappear like shown belowCapture.PNG

      Adobe Acrobat XI Version 11.0.11

      Any Help would be appreciated

      Author's profile photo Sateesh Kumar
      Sateesh Kumar
      Blog Post Author

      Hi Nikhil ,

      Sorry for very late reply .

      Use BOJAPAN font for your column with these special characters .

      Author's profile photo Former Member
      Former Member

      Excellent 🙂

      Author's profile photo Former Member
      Former Member

      Excellent. No need to create images and save on the BOBJ Server. 🙂

      Author's profile photo Jyothirmayee A
      Jyothirmayee A

      Thanks for Sharing the tips Sateesh,

      I'm using Char(9660) and Char(9650) for a conditional formatting but somehow these doesn't get exported to PDF.

      Any suggestions please?.

      Thanks,

      Jothi

      Author's profile photo Sateesh Kumar
      Sateesh Kumar
      Blog Post Author

      Hi Jyothi ,

      Glad you find it helpful.

      Use BOJAPAN font for your column with these special characters .

      Author's profile photo Naveen Reddy Yolugoti
      Naveen Reddy Yolugoti

      Hi Sateesh Kumar,

      Can you please look into this Horizontal Hexagon ASCII value not visible in webi discussion.

      I need a horizontal hexagon symbol, when i use =char(9108) I am getting (rectangle box). I tried changing font and also I tried in HTML/Applet and Rich client mode, it's not working anywhere.

      Can you please look into this issue.

      Thanks.

      Naveen.

      Author's profile photo Former Member
      Former Member

      Hi Naveen,

      Try Using Char(11042) for Filled Hexagon and Char(11041) for outlined Hexagon.

      Let us know if that works.

      -NSP

      Author's profile photo Naveen Reddy Yolugoti
      Naveen Reddy Yolugoti

      Hi Nikhil,

      I am still getting the rectangle box if i use CHAR(11041).

      FYI, I am using BO 4.1 SP7 and these are my webi preferences

      /wp-content/uploads/2016/10/webi_preferences_1049330.jpg

      Author's profile photo Sateesh Kumar
      Sateesh Kumar
      Blog Post Author

      Hi ,

      What result you are getting . Check the column/cell is formatted as "Text" .

      Check any conditional formatting is overwriting result.

      Thanks

      Author's profile photo Naveen Reddy Yolugoti
      Naveen Reddy Yolugoti

      Hi Sateesh,

      I haven't applied any kind of formatting on cell. I just took an empty cell and placed this formula =char(9108) over there.

      /wp-content/uploads/2016/10/hexa_text_1049378.jpg

      Author's profile photo Mahboob Mohammed
      Mahboob Mohammed

      Hi Naveen,

      There is a better and simple way to get those icons without using the Char() function.

      1. Open Excel (I've MS Office 2010), click in a blank cell, go to Insert tab (from top) -> click on Symbol (near far right)
      2. In the window that opens up, from the drop down on right for Subset select Miscellaneous Symbols, double click on the all the symbols you want, up arrow, down arrow etc. You'll see them added to a cell in Excel sheet. Close this Symbol window.
      3. Copy those symbols from Excel and paste them in Webi cell (to test).

      Voila!

      I was able to get it. Let us know if you're successful. Apart from that, you can get a lot of stuff directly by copying from Excel.

      Thanks,

      Mahboob Mohammed

      Author's profile photo Naveen Reddy Yolugoti
      Naveen Reddy Yolugoti

      Thanks Mahaboob,

      Your approach looks good to get different type of arrows, symbols, shapes, etc. It saves lot of time searching for codes and then converting them to ASCII values.

      FYI, I am unable to find horizontal hexagon in the EXCEL symbols.

      Actually I want to display text like this in webi for a flow chart type of report.

      /wp-content/uploads/2016/10/hexagon_1049379.jpg

      but when I use this symbols in webi, I am getting a very thick border like this:

      I am currently displaying symbol first (with 200 or 300 font size) and then on top of it I am adding a text box to display the text/data.

      Hex_text.jpg

      Do you know any solution, so that we can have a text box in any shape needed.

      Thanks & Regards.

      Naveen.

      Author's profile photo Mahboob Mohammed
      Mahboob Mohammed

      Hi Naveen,

      Why not try to use Images? Because, we can get text in the Symbol, even if it exists.

      Thanks,

      Mahboob Mohammed

      Author's profile photo Naveen Reddy Yolugoti
      Naveen Reddy Yolugoti

      Thanks Mahaboob for your help.

      It looks like using it as a image is better solution.

      Author's profile photo Former Member
      Former Member

      Naveen,

      Make sure your font type is Wingdings2.

      -NSP

      Author's profile photo Former Member
      Former Member

      Hi Sateesh,

      Is there any way to Conditionally format the Heat Map in Web Intelligence Rich Client?
      If yes then can i do it based on the Object used in the Category Axis?

      I have a requirement in Heat Map, where the Map should be having the Thresholds ( 3 types and three colors) for 26 different KPIs. which have 3 different thresholds for each KPI.

      Hope i could get a reply from anyone.

      Regards,