topic CONCAT with Aggr in QlikView

CONCAT with Aggr

robert_mika — Mon, 02 Feb 2015 06:30:14 GMT

Having this INLINE set

LOAD * Inline

[

Month,Group,val

1,A,1

2,A,2

3,A,3

1,B,4

2,B,5

3,B,6

1,C,7

2,C,8

3,C,9]

I'm, getting

15/24/6

when evaluating

CONCAT(Aggr( sum(val), Group))

The number are right but (and please correct me here) should not that be

6/15/24

Re: CONCAT with Aggr

anbu1984 — Mon, 02 Feb 2015 06:57:05 GMT

CONCAT(Aggr( sum(val), Group),'/',Aggr( sum(val), Group))

Re: CONCAT with Aggr

jonathandienst — Mon, 02 Feb 2015 07:30:41 GMT

I think concat uses load order, so I would have expected to see A/B/C in your results. You can ensure the load order by doing an inline load of just Group, in the required order, before you load the detail. The first load of a field determines the load order. That might work.

HTH

Jonathan

Re: CONCAT with Aggr

MarcoWedel — Mon, 02 Feb 2015 09:41:17 GMT

Hi,

one solution could be:

=CONCAT(Aggr( sum(val), Group),'/',FieldIndex('Group',Group))

hope this helps

regards

Marco