Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
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

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Try with 'Indent Mode' in the Style tab as shown here: Creating a Tree view in a Pivot table

View solution in original post

5 Replies
tresesco
MVP
MVP

Check this document: Hierarchies

razvan_brais
Creator III
Creator III
Author

Hy there. I have created the tables using hierarchies but , what I want to achieve is that i want that hierarchy to be in a column from a pivot table , such as a treeview from a listbox. I couldn`t find any solution on that.

tresesco
MVP
MVP

Try with 'Indent Mode' in the Style tab as shown here: Creating a Tree view in a Pivot table

View solution in original post

razvan_brais
Creator III
Creator III
Author

Nope , this isn`t what i`m looking for. I want to have on the first column the unique ID such as UserID. and when I click on + in the second column I would like to have The first level associated for that ID , then when I click on + to show the next level and so on. Something like this:

tree.PNG

razvan_brais
Creator III
Creator III
Author

After a few hours of researching ) ) I found out that what you suggested is the correct answer , all what I had to do is to modify subtotal position , and I obtained what I needed.

Thank a lot.