topic Re: expand associations under same column in QlikView

expand associations under same column

razvan_brais — Wed, 25 Nov 2020 16:16:04 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

Group1

-Group2

-Group3

Group1

-Group2

-Group3

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

Thank you

Re: expand associations under same column

tresB — Wed, 21 Sep 2016 06:25:29 GMT

Check this document: Hierarchies

Re: expand associations under same column

razvan_brais — Wed, 21 Sep 2016 08:12:51 GMT

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.

Re: expand associations under same column

tresB — Wed, 21 Sep 2016 08:18:26 GMT

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

Re: expand associations under same column

razvan_brais — Wed, 21 Sep 2016 08:29:04 GMT

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:

Re: expand associations under same column

razvan_brais — Wed, 21 Sep 2016 12:18:02 GMT

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.