topic AGGR Function - set analysis in QlikView

AGGR Function - set analysis

Tue, 22 May 2012 14:02:02 GMT

Hi all

I have a table with many columns:

Col1 = Has date values (With duplicates)

Col2 = Has different values for every different date (The same value is on the same date)

Col3 = Has Product1,Product2,Product3,Product4 (Only these products exists)

is it possible to sum the values in Col2 but only selecting distinct dates.

This mus be done in SET Analysis or the expressions

Kind regards

Martin

AGGR Function - set analysis

Anonymous — Tue, 22 May 2012 14:20:55 GMT

Try this:
aggr(sum(Col2),Col1)

Note that DISTINCT is default for aggr()

-Phil

AGGR Function - set analysis

Tue, 22 May 2012 14:43:13 GMT

This is my code

Col1 = WorkingDaysAMR

Col2 = ActivityDateTarget

=aggr(sum({1<ActivityDateTarget = {'>$(vSaveCensusDate)'}>}WorkingDaysAMR),ActivityDateTarget)

and it still returns bull values. any Ideas, thanks

AGGR Function - set analysis

Tue, 22 May 2012 14:49:14 GMT

Ive also taken the "1" out in the above set analysis but returns a Zero... thanks

AGGR Function - set analysis

Anonymous — Tue, 22 May 2012 15:27:14 GMT

My advice would be to break this down into pieces to determine where the problem is. For example, try the set analysis in an expression without the aggr(), and try the aggr() without the SA. Once you narrow down where the error(s) is/are, you can combine it back together.
-Phil