Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Rolands
Partner - Contributor II
Partner - Contributor II

Hierarchy node (base) level flag field

Hi!

Building up my first hierarchy - and have one question. How can I create node (or base) level flag in my data.

Here is my raw test data:

clipboard_image_0.png

 

The script I have created:

clipboard_image_1.png

My output data:

clipboard_image_2.png

 

The hierarchy works like a charm, and every thing is perfect, but.. always but! I need to create a flag for node level elements (lowest ones) or for consolidated elements, for further  analysis.

 

So what I need:

clipboard_image_3.png

 

Hope, the question is clear!

 

Thank you in advance!

 

Labels (2)
1 Solution

Accepted Solutions
Rolands
Partner - Contributor II
Partner - Contributor II
Author

Hi!

Yes @acgomes - I found solution.

Rolands_0-1632896479144.png

I'm using HierarchyBelongsTo and afterwards from this dataset you can get consolidated elements with "where DethDiff <>0" when loading only groups from previous dataset;

 

So, when you have this flag for group, further you can freely operate with it! 

 

Cheers!

 

 

 

 

 

 

View solution in original post

2 Replies
acgomes
Partner - Contributor III
Partner - Contributor III

Hello Rolands,

Did you find a solution?

acg

Rolands
Partner - Contributor II
Partner - Contributor II
Author

Hi!

Yes @acgomes - I found solution.

Rolands_0-1632896479144.png

I'm using HierarchyBelongsTo and afterwards from this dataset you can get consolidated elements with "where DethDiff <>0" when loading only groups from previous dataset;

 

So, when you have this flag for group, further you can freely operate with it! 

 

Cheers!