Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I know that you are able to to the HierarchyBelongsTo function to be able to see the full ancestry (parents, grand-parents, etc.) in a hierarchy. I was wondering if anyone has thought of a good way to see all of the decedents (children, grandchildren, etc.) as well without seeing the "cousins"?
To explain this a little better imagine the following structure:
1. World
2. North America
3. United States
4. Alabama
4. Alaska
4. Arizona
...
3. Canada
4. Alberta
4. British Columbia
...
2. Europe
3. France
4. Centre
4. Limousin
...
3. Spain
4. Aragon
...
...
...
So, if I was to select North America, I would be able to see that it was connected to the following:
However, if I was to select United States, I would see that it was connected with the following:
Any thoughts on this would be much appreciated.
I could not rule out the expression, but it works the way you want it.
I could not rule out the expression, but it works the way you want it.
Hi Todd, that kind of structures can be generated with the Hierarchy() function: https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/ScriptPrefixes/Hierarc...
Thank you very much. It is not perfect (because of the expression that I think would be impossible to get rid of), but I do think that I could build off that and could find at least one relevant expression to add to the pivot table. As a note, using the Hierarchy function, it seems you would build this pivot table with Node names that get created by the script (in this case it would be Node_Name1 - Node_Name4
Todd:
I had done a visual with hierarchy display:
check it out here:
Gerry - This is great. Thanks for putting this together!
Todd:
I can help you deploy this solution in your organization - pro bono.
You might need some hand holding with the code...
FYI ... this can be setup to handle multiple hierarchies, with varying levels of depth.