topic Dynamic Multi-Pass Hierarchy Prep Recursion in QlikView

Dynamic Multi-Pass Hierarchy Prep Recursion

Fri, 25 Mar 2011 20:45:53 GMT

Hi Everyone,

What's an elegant way to programmatically streamline the pre-Hierarchy function recursion passes for a (potentially variable) multi-column hierarchy?

I'm thinking the FieldName() and FieldNumber() functions, maybe following a few user-answered questions in variables (Ex. What's the starting column, and how many columns are part of the hierarchy?) are the key to making this into a loop.

Thanks,

Dynamic Multi-Pass Hierarchy Prep Recursion

pover — Fri, 25 Mar 2011 22:08:02 GMT

Why would you not use the Hierarchy or HierarchyBelongsTo function?

Regards.

Dynamic Multi-Pass Hierarchy Prep Recursion

Fri, 25 Mar 2011 22:11:57 GMT

This is to prep the table for the Hierarchy and HierarchyBelongsTo functions.

Dynamic Multi-Pass Hierarchy Prep Recursion

pover — Sat, 26 Mar 2011 18:31:46 GMT

Ok, so the object of the script is to create a table with a parent ID in each row. Can you upload a same sample of the data you are starting with?

Regards.