Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

d4rlie891
New Contributor III

How to Get Sum or Total of Distinct Value

HI,

Anyone Can Help me, how to create a set Analysis for this case :

I want to create a set Analysis to get the Sum of Count Distinct Value ->112656.

I tried to create a set Analysis but result is 6,305.

Sum of Distinct Value.png

Thanks

Dmw

1 Solution

Accepted Solutions
vinieme12
Esteemed Contributor II

Re: How to Get Sum or Total of Distinct Value

Your KPI object is showing correct distinct count, your table is showing you a sum of rows

if you want to match the same, try below

=sum(AGGR(  COUNT(....), DAY))

6 Replies
Highlighted
qlikdeez
Valued Contributor

Re: How to Get Sum or Total of Distinct Value

Try using aggr

Re: How to Get Sum or Total of Distinct Value

Image showing Simple Distinct. But, KPI seems Total keyword(Don't required to get the same). Can you cross check/ Copy paste the expression. or else you may share sample to get it

d4rlie891
New Contributor III

Re: How to Get Sum or Total of Distinct Value

This is the expression : Count({$<MONTHYEAR = {"$(=max(MONTHYEAR))"}>} Distinct JOB_MEM_NAME).

I also attach the sample data

Thanks !

vinieme12
Esteemed Contributor II

Re: How to Get Sum or Total of Distinct Value

Your KPI object is showing correct distinct count, your table is showing you a sum of rows

if you want to match the same, try below

=sum(AGGR(  COUNT(....), DAY))

Re: How to Get Sum or Total of Distinct Value

What are the Dimensions here, Can you tell us MONTHYEAR. How you are taken this?

d4rlie891
New Contributor III

Re: How to Get Sum or Total of Distinct Value

ok thanks Vineeth. it works using this expression :

sum(AGGR(COUNT(Distinct {$<MONTHYEAR = {"$(=max(MONTHYEAR))"}>} JOB_MEM_NAME), DAY))

Community Browser