Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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)

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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)

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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)
itsme123
Contributor III
Contributor III
Author

Thank you for quick response