Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
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