topic Re: Tree view in pivoted table in QlikView

Tree view in pivoted table

Fri, 14 Aug 2015 08:35:31 GMT

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:

b11

b12

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.

Re: Tree view in pivoted table

mohammadkhatimi — Fri, 14 Aug 2015 09:43:57 GMT

PFA..

Hope this will helps you...!!

Regards,

Mohammad

Re: Tree view in pivoted table

parthakk — Fri, 14 Aug 2015 09:50:04 GMT

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

Re: Tree view in pivoted table

vardhancse — Fri, 14 Aug 2015 10:04:30 GMT

Hi,

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

Re: Tree view in pivoted table

qlikviewwizard — Fri, 14 Aug 2015 10:16:35 GMT

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

Hierarchy and Hierarchy Belongs to

Re: Tree view in pivoted table

parthakk — Fri, 14 Aug 2015 10:16:49 GMT

Hi this is a similar view obtained using list box

Re: Tree view in pivoted table

vardhancse — Fri, 14 Aug 2015 10:18:41 GMT

Hi,

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

Re: Tree view in pivoted table

Mon, 17 Aug 2015 03:22:06 GMT

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,

Re: Tree view in pivoted table

Mon, 17 Aug 2015 03:37:58 GMT

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,

Re: Tree view in pivoted table

Mon, 17 Aug 2015 03:44:27 GMT

Hi,

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

Thanks and Regards,