Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
razvan_brais
Creator III
Creator III

expand associations under same column

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

Column1Column2
1

Group1

     -Group2

           -Group3

2

Group1

     -Group2

           -Group3

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

Thank you

0 Replies