Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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)
1 Solution

Accepted Solutions
Highlighted

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
Highlighted

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

Highlighted
Contributor III
Contributor III

Thank you for quick response