Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I created Hierarchy View in Pivoted table succesfully with the guide as link: Qlikview - Hierarchy vs Hierarchy belongs to - YouTube
However, instead of showing pivoted table in normal (horizontal view), I would like to show in Tree view as follows:
a
a1
a2
b
b1
b11
b12
b2
I find in through forum but no result is clear. I also see this link Using tree structure in the pivot table? but with QlikView Personal edition, I cannot open the attached file. Please kindly help me to solve this issue.
Thank you in advance.
PFA..
Hope this will helps you...!!
Regards,
Mohammad
Hi,
Am not sure of pivot table but u can achieve a similar one using list box.. Combine all d fields in script and give an alias i.e
field1 &' /' & field2 & '/' & field3 as FIELD
Now choose FIELD in list box and there u get tree option as select delimiter as '/'.. U can achieve a similar result. also u can use expressions
Thanks,
Partha kulkarni
Hi,
In list box we can achieve the tree view, but not sure in pivot/straight table its possible.
Hi Please check Jagan's app. Hope this will help you.
Hi this is a similar view obtained using list box
Hi,
The requirement was to display tree view in a pivot table, but in the link the tree view was there in list box.
Hi,
Thank you for your advices. I performed your suggestion successfully. Acctually, the report looks like "Balance sheet", please see the attached picture file for more information. If I used "List box", I cannot show the "Current Year" amount and "Previous Year" amount in the same row with "Assets".
I tried "Pivoted table" but It cannot show in "Tree view". Could you give me any idea?
Thanks and Regards,
Hi,
Thank you for your suggestion. if we used "List box", is it possible for showing another dimention/measure in list box? See my attached picture for more information:
Thanks and Best Regards,
Hi,
Actually, I used Qlikview Personel edition so I cannot open any downloaded Qlikview file. could you give me another suggestion?
Thanks and Regards,