topic Re: Grouping in QlikView

Grouping

narayanamsn — Fri, 20 Apr 2018 06:07:37 GMT

Hi,

I have a situation where in I need to group the values of one column and project the metric for the total as well in chart(not in table)

sunny_talwar — Fri, 20 Apr 2018 09:00:29 GMT

Would you be able to share your Excel file as a file instead of image?

sunny_talwar — Fri, 20 Apr 2018 14:16:01 GMT

This is what you are looking to get?

narayanamsn — Sat, 21 Apr 2018 05:53:50 GMT

Yes Sunny, Did you create any other inline table to refer the Region?

its_anandrjs — Sat, 21 Apr 2018 08:47:38 GMT

You can try to use Pick function here for your output.

Regards

Anand

sunny_talwar — Sat, 21 Apr 2018 11:36:34 GMT

I did... here is the script I used

Table:

LOAD If(Match(State, 'UP', 'MP', 'Bihar'), 'North', 'South') as Region,

LOAD * INLINE [

State, Month, Spend, Population

UP, 1, 10, 8

MP, 1, 5, 3

Bihar, 1, 8, 7

Kar, 1, 4, 4

UP, 2, 12, 8

MP, 2, 6, 3

Bihar, 2, 6, 7

Kar, 2, 5, 4

];

LOAD * INLINE [

Dim

];