topic Re: How to add conditional flags in Qlik Sense KPI Charts ? in App Development

How to add conditional flags in Qlik Sense KPI Charts ?

Ankit3 — Mon, 23 Jan 2023 14:30:09 GMT

Hi All,

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

Please guide how to achieve this.

Thanks

KGalloway — Mon, 23 Jan 2023 22:20:12 GMT

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 — Wed, 25 Jan 2023 06:36:21 GMT

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]) )