expand associations under same column

razvan_brais — Tue, 20 Sep 2016 08:09:02 GMT

Hey guys.

I have 3 table created from excel file.

Level1:

LOAD ACC,

DESC

FROM

[excelFile]

(ooxml, embedded labels, header is 1 lines, table is [Sheet ]);

Level2:

Load

DESC,

Column1

FROM

[excelFile]

(ooxml, embedded labels, header is 1 lines, table is [Sheet ]);

Level3:

Load

Column1,

Column2,

Column3

Column4

FROM

[excelFile]

(ooxml, embedded labels, header is 1 lines, table is [Sheet ]);

Using these 3 tabel I created 3 groups as :

Group1: DESC

Group2:Column1,

Group3:

Column2,

Column3

Column4

All these info I inserted in a Pivot Table as dimmensions.

So now when I clik on a account , I will see the first Group info , I click + and see Group2 assocciated with the first group in a third column and so on. What I want to do is that I want to have a Pivot Table , with two Columns.

First column to be ACC and second Column to contain all of the three groups that are associated with the account.

I want that my table to look something like this

Column1	Column2
1	Group1 -Group2 -Group3
2	Group1 -Group2 -Group3

Column1

Column2

Group1

-Group2

-Group3

Group1

-Group2

-Group3

With the posibility of expanding each group info. Is there any way to make this happen?

Thank you

topic expand associations under same column in QlikView

expand associations under same column