# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
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
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)
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)
Highlighted
Contributor III

Thank you for quick response