Accumulated Distinct Count

[Anonymous]

Hi all,

Any idea how to get accumulated distinct count ?

Column Count is the result that I need to receive in QlikView.

Distinct Count for period 1 = 5,

Distinct Count for period 1+2 =7

Distinct Count for period 1+2+3 = 8

Thanks for your help.

[#2]

Hi Stefan,

my expression: does not entail Month into the aggr().

=if(Count([Name])<>0,rangesum(above(sum({<Month={'<=$(=max(Month))'}>}aggr(distinct count({<Month={'<=$(=max(Month))'}>} distinct [Name]),[Name])),0,RowNo())))

How would you write it to make it work correctly?

Thanks,

M