Interested to Buy Any Domain ? << Click Here >> for more details...
In a column if the value is >10000, it has to show downwards
Arrow in green color,
If the value is <10000, it has to show upwards arrow in red
Color....
How to achieve this?
- 4 Answers
- 13523 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / anjireddy pothireddy
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)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
What are the data types present in bo? What happens if we implement view in the designer and report?
what is xcelsius architecture?
Explain what are the steps to do to use alerts in bo?
U r project in which stage in implementation?
Which versions are used in the bo dashboard work?
Give some information on report bursting?
How we drill up week to month?
Explain about a tricky situation for which you found a very simple solution?
Can we create universe with no cache??
Explain is there any default username & pwd for bo designer & supervisor?
How to generate the report from excel sheet?
How to open a universe with out using the Designer ??
What is a bo repository?
