How to add conditional flags in Qlik Sense KPI Charts ?

[Ankit3]

Hi All,

My requirement is to show  ▲ arrow when Sales Growth is >5000 else  ▼ arrow.

Please guide how to achieve this.

Thanks

[KGalloway]

It will depend on what calculation you use to get Sales Growth. For my example, I assume a simple sum:

if(sum([Sales Growth]) > 5000, sum([Sales Growth]) & ' ▲', sum([Sales Growth]) & '  ▼')

This would show the following for a Sales Growth value of 5237:

5273 ▲

and it would show the following for a value of 4222:

4222 ▼

[vinieme12]

I would suggest using the expression shared by @KGalloway  but encapsulating it in Dual() as  below

=Dual ( Num(sum([Sales Growth]),'#,##0') & if(sum([Sales Growth]) > 5000,' ▲', '  ▼') ,  sum([Sales Growth]) )