aggr and set analysis

Thu, 19 Jan 2012 23:53:22 GMT

In a textbox, why does the following give the result "alfa, gamma" instead of just "alfa" ?

=concat({$<Names={alfa,gamma}>}
aggr({$<Names={alfa,beta}>}Names , Names
),',')

the Names table looks like this:

Names

alfa

beta

gamma

I cant get the aggr function to work with set analysis. I always need to put in another function like sum or concat to limit the data set with.

But the manual does say that sets work in aggr:

"By default, the aggregation function will aggregate over the set of possible records defined by the selection.

An alternative set of records can be defined by a Set Analysis (page 805) expression."

and

"aggr ([ distinct | nodistinct ] [{set_expression}]expression {,dimension})"

/help much appreciated

fosuzuki — Fri, 20 Jan 2012 02:49:14 GMT

Hi,

Actually I think your expression has an error. Inside your aggr() function there should exist a set expression like concat().

"aggr ([ distinct | nodistinct ] [{set_expression}]expression {,dimension})"

Hope this points you in the right direction.

Regards,

Fernando

topic aggr and set analysis in QlikView