topic Re: Subcolumn in table in QlikView

Subcolumn in table

Wed, 23 Apr 2014 11:58:26 GMT

Hi,

Do you know how possible combine columns as described below? (Straight table or Pivot table)

Re: Subcolumn in table

whiteline — Wed, 23 Apr 2014 12:34:39 GMT

Hi.

You can use PIVOT table to show such structure.

Re: Subcolumn in table

its_anandrjs — Wed, 23 Apr 2014 12:49:56 GMT

You can use combination of Straight table and Pivot table.

Re: Subcolumn in table

Wed, 23 Apr 2014 13:13:21 GMT

Create a dummy field for a dimension which incorporates the key differentiator of the "column group", use this field to create the split you require above.

Re: Subcolumn in table

Roop — Wed, 23 Apr 2014 14:49:57 GMT

Omit the first 2 rows and then work from there. Work with the columns as opposed to the headers.

Re: Subcolumn in table

Wed, 23 Apr 2014 14:59:41 GMT

Im also curious on how this can be done. Can anyone post a sample? Thanks in advance!

Re: Subcolumn in table

Roop — Wed, 23 Apr 2014 15:09:21 GMT

I think that this is what you require:

TableDesc:

LOAD

A as Column1,

B as Column2,

C & D as Column3_Concatenated_Together,

E as Column4

FROM junk.xlsx (ooxml, no labels, header is 2 lines, table is Sheet1);