Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. Learn More!
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 (1)
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!