Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
From the example below I want to get the formula to get the green value in a simple KPI for customer Type A. So the outcome will only be 235 and as a title for the KPI I can use Type A.
Can someone help me with this?
Many thanks in advance!
Best regards,
Roy
sum({<Customer={'Type A'}>}Registrations)
-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com
sum({<Customer={'Type A'}>}Registrations)
-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com
Hi Rob,
Thank you very much! I got one more (perhaps very simple question). But how would the formula change if the data set would look like this:
So in this case, there is no customer Type A or B anymore. Which part of the formula could be left out to plot it in a KPI.
Best regards,
Roy
Sum(Registrations)
-Rob