# 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
Did you mean:
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

 ColA ColB ColC 1 123 \$10 2 123 \$10 3 123 \$10 4 123 \$10 KPI 1 5 123 \$10 Col c \$10+\$40 1 444 \$40 2 444 \$40 KPI 2 3 444 \$40 Distinct of col b count 4 444 \$40 5 444 \$40
Labels (1)
• ### KPI

1 Solution

Accepted Solutions

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)
2 Replies

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

Thank you for quick response

Community Browser