topic Grouping in QlikView

Grouping

Wed, 13 Jul 2011 23:06:45 GMT

Id Val

1 B

2 A

3 B

If I group By “ID”

Id Val

Is there a way I can group my ID 2 and ID 3 also to VAL “AB” since they have at least one value matching.

Suggestions ??

Re: Grouping

Thu, 14 Jul 2011 15:05:30 GMT

Use this:

tmp:
LOAD *, Val as tmpVal INLINE [
    Id, Val
    1, B
    1, A
    2, A
    3, B
];
load Id,
    concat(tmpVal) as Val
resident tmp
group by Id
order by Id, Val;
drop table tmp;