Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
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
Highlighted
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))

View solution in original post

6 Replies
Highlighted
Valued Contributor

Re: How to Get Sum or Total of Distinct Value

Try using aggr

Highlighted

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

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
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 !

Highlighted
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))

View solution in original post

Highlighted

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?

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