Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
lakshmanvepuri
Creator
Creator

Color Coding for the Summary

Hi Gurus, 

 

Please let me know how do I achieve this.

 

SPEND

119000

90040

Budget

100000

100000

Diff

[19000]

[9960]

 

+19%

-10%

 

•For spend

-Red if value exceeds budget, indicating overspend

-Green if value doesn’t exceed

Note:

Summary tab to show the percentage and actual values that exceed or below target.

Text and color coding should follow exactly like shown above.

 

Thanks a lot.

Regards

Vepuri

 

Labels (2)
2 Replies
Zhandos_Shotan
Partner - Creator II
Partner - Creator II

Hi!

Use cell text color expression:

If([SPEND]/[BUDGET]-1>0, Red(), Green())

lakshmanvepuri
Creator
Creator
Author

Hi @Zhandos_Shotan ,,

 

I got the result earlier  but  not getting like.. as shown in the screenshot (Color Coding)

lakshmanvepuri_0-1617464873431.png

Thanks

Vepuri