topic Group Values in QlikView

Group Values

Fri, 14 Sep 2012 21:00:53 GMT

Hello All,

I have a list box with Values A,B,C.

I want to create a group athe values 'A','B','C' to group them into one value called 'All' along with the indiviual values. The final inbox should be somewhat like

All.

How can we do it here in other reporting tools, we could achieves this by grouping values.

Thanks

Re: Group Values

swuehl — Fri, 14 Sep 2012 21:17:03 GMT

You can prepare your group in the script, like

LIST:

LOAD * INLINE [

List

];

LIST2:

LOAD List as List2, List Resident LIST;

LOAD 'All' as List2, List Resident LIST;

Then use field List2 for your list box.

Hope this helps,

Stefan