# 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.

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

6 Replies
Highlighted
Valued Contributor

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

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