Count the total registrations for a dimension as a KPI

[Roy2]

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

[rwunderlich · Accepted solution]

sum({<Customer={'Type A'}>}Registrations)

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

[Roy2]

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 

[rwunderlich]

Sum(Registrations)

-Rob