Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
SunainaUmberkar
Contributor III
Contributor III

Hierarchy of Levels in Qliksense

Hello All,

I have a scenario of showing Level wise Materials in pivot table.

We have some levels defined from 1 to 12. And each material is associated with Levels. There is a hierarchy of Materials. Level 1 Material has Level 2 Material,Level 2 has Level 3 and so on. All these materials from any level are defined in the same column. To identify which material comes under which Level we have a Node and Parent value. Also we have a column that says whether material is Expanded and Leaf. If material has a child then it is given a flag as Expanded, And if there is no child then it is defined as leaf.

Please find the attached excel where we have Levels,Material,Node and Parent Value. 

Here for ex, For level1 Material BA00003589668, We have Level2 Material BA00002460360 and this level2 MAterial has
Level3 material BA0000247329. Now this is identified only by matching the Parent value with the Node Value.
Like Node value of Level1 Material(BA00003589668) 83445.1 is matching with Parent value of Level2 Material(BA00002460360).

Similar way, Level2 Material (BA00002460360) Node value 0000083445.1-0000083506.12 is matching with Level3 Material(BA00002473290) parent value 0000083445.1-0000083506.12.
This is the only way to identify as which Material falls under which level Material. It also has a state column which says about expanded and leaf.

I need to show this hierarchy in pivot table as like below. But since all the Materials are in same column we are unable to get below view.

SunainaUmberkar_0-1658811468865.png

Kindly assist. Thanks in advance.

Labels (1)
1 Solution

Accepted Solutions
SunainaUmberkar
Contributor III
Contributor III
Author

Hello All,

I solved this by using Hierarchy in script. Below is the script.

Table1:

Load Level,

Material,

Parent,

Node

from Sampledate.xlsx;

Noconcatenate

Hieararchy(Node,Parent,Material)

LOAD Distinct

NODE,

PARENT,

Material

Resident Table1;

Table2:

Load

Node,

Level,

from Sampledata.xlsx;

 

 

View solution in original post

2 Replies
SunainaUmberkar
Contributor III
Contributor III
Author

Hello All,

Kindly assist on above scenario.

Thanks in advance.

SunainaUmberkar
Contributor III
Contributor III
Author

Hello All,

I solved this by using Hierarchy in script. Below is the script.

Table1:

Load Level,

Material,

Parent,

Node

from Sampledate.xlsx;

Noconcatenate

Hieararchy(Node,Parent,Material)

LOAD Distinct

NODE,

PARENT,

Material

Resident Table1;

Table2:

Load

Node,

Level,

from Sampledata.xlsx;