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

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
BHoll
Contributor III
Contributor III

Hierachy Load

Hello everyone,

i read up on hierachy load in this post:

https://community.qlik.com/t5/QlikView-Documents/Hierarchy-function-easy-and-Efficient-with-example/...

but i'm not really sure if i can apply this knowledge to my problem. I got a table with a keyfield and 2 x 3 fields ,which i have to transform into a hierachy form. The table also contains two fact fields.

Looking at the example file i want to create 2 tree listboxes, the first one containing Seller, Country(of customer), Customer Name. The second listbox should contain Method1, Method2 and Method 3. The listboxes need to be linked to the fact fields Weight and Factory.

IF a user selects a certain factory, all nodes in the listboxes that don't contain the factory should become grey. This should ofcourse work for all factories and weights.

 

Best regards,

BHoll

 

 

 

1 Reply
Brett_Bleess
Former Employee
Former Employee

Hey Benjamin, have a look at the following Design Blog post, hopefully this may get you headed in a good direction.  Feel free to do some further searching in the entire Design Blog area as well, just change the URL below to hit that level, and you will get a search box, I will post both URLs for you... 🙂

https://community.qlik.com/t5/Qlik-Design-Blog/Unbalanced-n-level-hierarchies/ba-p/1474325

Design Blog search URL:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Hopefully this helps.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.