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...
Hi!
Hope this is what you want.
Expression of comment filed in the chart.
=if((sum(Sales)/sum(Target)*100)>=90 and (sum(Sales)/sum(Target)*100)<100,'Silver',
if((sum(Sales)/sum(Target)*100)>=100 and (sum(Sales)/sum(Target)*100)<110,'Gold',
if((sum(Sales)/sum(Target)*100)>=110,'Diamond')))
try use <=89
could you please share your qvw?
Hiya,
Not too sure if I understand your question correctly, but you should be able to get what you're looking for by either using:
Might be best to create a simple example by using dummy data and load the qvw to better illustrate what you're after.
use .90 as it is in %
.100
.110
inpalce of 90,100 and 110
hope this helps
Hi!
Hope this is what you want.
Expression of comment filed in the chart.
=if((sum(Sales)/sum(Target)*100)>=90 and (sum(Sales)/sum(Target)*100)<100,'Silver',
if((sum(Sales)/sum(Target)*100)>=100 and (sum(Sales)/sum(Target)*100)<110,'Gold',
if((sum(Sales)/sum(Target)*100)>=110,'Diamond')))
You haven't stated what you want to show if 'Silver' 'Gold' and 'Diamond' do not apply, i.e. everything below 90.
Assuming you want below 90 to show 'Bronze' change the end of your expression to this:
......110,'Diamond','Bronze')))
.
Thanks Its Work For Me
Its a pleasure to help.
Please mark it as correct answer if its work for you.
how to count no of silver ,gold & Diamond.