Tree view in pivoted table

[#1]

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.

[mohammadkhatimi]

PFA..

Hope this will helps you...!!

Regards,

Mohammad

[parthakk]

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

[vardhancse]

Hi,

In list box we can achieve the tree view, but not sure in pivot/straight table its possible.

[qlikviewwizard]

Hi Please check Jagan's app. Hope this will help you.

Hierarchy and Hierarchy Belongs to

[parthakk]

Hi this is a similar view obtained using list box

[vardhancse]

Hi,

The requirement was to display tree view in a pivot table, but in the link the tree view was there in list box.

[#8]

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,

[#9]

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,

[#10]

Hi,

Actually, I used Qlikview Personel edition so I cannot open any downloaded Qlikview file. could you give me another suggestion?

Thanks and Regards,