topic Re: Count Distinct Total in QlikView

Count Distinct Total

kevbrown — Tue, 17 Jun 2014 08:39:53 GMT

I'm looking to create a table that looks distinct values and includes a total. However, using the total function on Dimension Limits is also distincting the values and therefore the amounts so match, for example

Status Amount

a 10

b 20

c 30

d 40

e 50

f 60

g 70

Total 250

I'm putting the data in NPrinting and need the total to be shown so can't use the function Total Mode on the Expressions tab as this doesn't pull into NPrinting.

Any idea?

Kev

Re: Count Distinct Total

Gysbert_Wassenaar — Tue, 17 Jun 2014 08:55:23 GMT

Try sum(aggr(count(distinct MyValue),Status))

Re: Count Distinct Total

ashfaq_haseeb — Tue, 17 Jun 2014 08:57:12 GMT

Hi,

Why don't you use default output of straight table.

Look at the attached application.

Or if you have non distinct values then use below formulae.

sum(aggr(sum(distinct Amount),Status))

Regards

ASHFAQ

Re: Count Distinct Total

SergeyMak — Tue, 17 Jun 2014 08:58:06 GMT

it's not clear for me but

try to use:

SUM(DISTINCT Amount) or

Sum(AGGR(SUM(Amount),Status)) or

IF(Dimensionality=0,SUM(Total Amount),Sum(Amount))

Please, share an app