Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
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)