topic Sum Distinct with SET Parameter in QlikView

Sum Distinct with SET Parameter

Tue, 18 Jan 2011 23:20:27 GMT

Hi to all
I have a problem I need to sum distinct values in a range

es.

I want that consider the sum = 20 because on 2/1/2010 there are two same values. I solve the problem with this formula

SUM( AGGR(SUM( DISTINCT (Bdg_vendita)), [Data]))

the problem is that in the same table I need to shows data to the previous year. I try to use this

Sum( AGGR(SUM({ $ <Anno_Fisc={$(ANNO_FISC_PREC)}> } DISTINCT (Bdg_vendita)), [Data]))

and this

Sum({ $ <Anno_Fisc={$(ANNO_FISC_PREC)}> } AGGR(sum( distinct(Bdg_vendita)), Data))

...but it doesn't works... 😞

any ideas ?

THANKS
Andrea

johnw — Tue, 18 Jan 2011 23:55:23 GMT

I believe you need the set in both places instead of just one or the other. So probably this?

sum({<Anno_Fisc={$(ANNO_FISC_PREC)}>} aggr(sum({<Anno_Fisc={$(ANNO_FISC_PREC)}>} distinct Bdg_vendita),Data))

Wed, 19 Jan 2011 00:04:39 GMT

GREAT IT WORKS !!!

🙂

THKS

Andrea