Discussion Board for collaboration related to QlikView App Development.
I have data like below.
and I am looking like below
Can some one help me to get loop/hirarchy for the above example.
You can look into the HIERARCHY and HIERARCHYBELONGSTO LOAD prefixes to transform your table:
This will not exactely reproduce your output table, but will return tables that can be used well in QV analysis.
Hope this helps.