Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
itsme123
Contributor III
Contributor III

Need help with Qlikview KPI Expression

Need help in create below two KPI's

First KPI  :   column b 123 has amount $10 and 444 has $40 i just need to pick distinct value of col b and there respective amount to be sum $10 +$40 = 50 this should be my KPI result

Second KPI : I need distinct count of col b = 2 should be my KPI result

ColAColBColC  
1123$10  
2123$10  
3123$10  
4123$10 KPI 1
5123$10 Col c $10+$40
1444$40  
2444$40 KPI 2
3444$40 Distinct of col b count
4444$40  
5444$40  
Labels (1)
  • KPI

1 Solution

Accepted Solutions
Anil_Babu_Samineni

KPI1 : Sum(Distinct ColC)

KPI2 : Count(DISTINCT ColB)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

2 Replies
Anil_Babu_Samineni

KPI1 : Sum(Distinct ColC)

KPI2 : Count(DISTINCT ColB)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

itsme123
Contributor III
Contributor III
Author

Thank you for quick response