Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

bishnuhsbc
New Contributor

Calculation Condition KPI

Hi Folks,

I have a column where duplicate entry is there and while selecting KPI with count it is counting even duplicate values so can anybody let me know how to avoid duplicate values so that I can get a exact count.

Thanks & Regards

Tags (3)
1 Solution

Accepted Solutions

Re: Calculation Condition KPI

Add the DISTINCT keyword to your count function.

-Rob

2 Replies

Re: Calculation Condition KPI

Add the DISTINCT keyword to your count function.

-Rob

bishnuhsbc
New Contributor

Re: Calculation Condition KPI

Thanks Rob, it worked. Keep in touch as I am new to this.

Regards

Bishnu

Community Browser