Qlik View Expression

[vijayit43]

My QlikView Dashboard Calculate Percentage in Expression Field When percentage >= 90 then show silver when percentage >=100 the show Gold When >=110 then show Diamond when Percentage <90 Don't show in my Qv How Is Possible ?????? Please Help...

[#2]

Simply you can write the 03 if conditions in 03 expression columns and replace 'Gold', 'Silver','Diamond' with 1.

By enabling the totals you can get the count.

Eg:

Silver Count:

=if((sum(Sales)/sum(Target)*100)>=90 and (sum(Sales)/sum(Target)*100)<100,1,0)