topic Grouping Rows in Table (Streight/Pivot) in QlikView

Grouping Rows in Table (Streight/Pivot)

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Need your help for grouping rows in Qlikview. Which table should I use?

Datasource is as below.

Column1 Column2

A 10

B 20

C 12

D 15

E 18

F 20

Need Output as below.

Column1 Column2

G1 30

G2 27

E 18

F 20

Regards,

Shankar

Re: Grouping Rows in Table (Streight/Pivot)

MindaugasBacius — Mon, 13 Feb 2017 09:57:28 GMT

Use Calculated Dimension in front end:

=If(Match(Column1, 'A', 'B'), 'G1',

If(Match(Column1, 'C', 'D'), 'G2', Column2))

Or create the new grouping logic while loading the data.

Re: Grouping Rows in Table (Streight/Pivot)

kaushiknsolanki — Mon, 13 Feb 2017 10:04:03 GMT

Hi,

Try this,

Map:

Mapping load * inline [

X,Y

A,G1

B,G1

C,G2

D,G2

];

Data:

Load *,ApplyMap('Map',Column1) as Group inline [

Column1, Column2

A, 10

B, 20

C, 12

D, 15

E, 18

F, 20

];

Regards,

Kaushik Solanki

Re: Grouping Rows in Table (Streight/Pivot)

Mon, 13 Feb 2017 11:15:54 GMT

Hi Kaushik,

irst Option is good but do we have any other option without changing my script.

Regards,

Shankar

Re: Grouping Rows in Table (Streight/Pivot)

kaushiknsolanki — Mon, 13 Feb 2017 11:34:58 GMT

Hi,

In that case you can try the option given by mindaugasbacius

Regards,

Kaushik Solanki