Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Tree view in pivoted table

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.

9 Replies
mohammadkhatimi
Partner
Partner

PFA..

Hope this will helps you...!!

Regards,

Mohammad

parthakk
Creator II
Creator II

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
Specialist III
Specialist III

Hi,

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

qlikviewwizard
Master II
Master II

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

Hierarchy and Hierarchy Belongs to

parthakk
Creator II
Creator II

Hi this is a similar view obtained using list box

vardhancse
Specialist III
Specialist III

Hi,

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

Not applicable
Author

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".

Balance Sheet.PNG

I tried "Pivoted table" but It cannot show in "Tree view". Could you give me any idea?

Thanks and Regards,

Not applicable
Author

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:

Balance Sheet.PNG

Thanks and Best Regards,

Not applicable
Author

Hi,

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

Thanks and Regards,