Discussion Board for collaboration related to QlikView App Development.
i want Show Parent Child Record In QlikView
Look Like This Sample.
Please Help Me.
Excel File Attach
Hope this helps.
First sheet table boxes to check how data is loaded.
2nd. sheet an example of pivot table.
when to set depends on script it can be anywhere, when you want or need to load the structure
View solution in original post
Hi leila, Hierarchy() and HierarchyBelongsTo() are used to create parent-child relations, as example:
(ooxml, no labels, table is Sheet1);
HierarchyBelongsTo (A, B, C, 'ParentId', 'ParentName')
Create table boxes with fields from different trables to check the result.
Hi Ruben ,
Thank you for your answer
But I Can not Understand When Set In Load Script,
You can write a practical example (Excel File Attach).
i want Show in Chart Look Like Pivot Chart
this is perfect Thanks,
Can also be applied on the chart without Hierarchy Or HierarchyBelongsTo in load Script.?
i want Load Clear in load Script And Pivot Show Hierarchy
I don't know a way to do in chart, maybe there is a way using calculated dimensions but if exists it would be more complex than creating in script