topic Hierarchy pivot table in QlikView

Hierarchy pivot table

Wed, 07 Oct 2009 20:09:35 GMT

Hi. I have a question regarding hierarchy in a pivot table.

Is there a way not to show levels which are empty (NULL)? Let me elaborate on that. Let's say we have the following dimension in a pivot table:

Level1 - Level2 -Level3 - Level4 - Level5 - Article

Transactions can exist on any level. Let's say that one transaction exists on Article level, and the only available hierarchy dimension is Level1 (for that record). All other levels (Level2 to Level5) will be NULL, and user has to "qlik" his way to reach the article level.

Is there a way (by using a calculated dimension, or some other way) to, in that case, put Article right after Level1?

Attached demo app just to get the feel of what I'm talking about.

Thank you for your help, fellow qlikviewers 🙂

Cheers,

Marko

Hierarchy pivot table

Wed, 07 Oct 2009 20:18:57 GMT

You could maybe try with calculated dimensions such as

IF(isnull(Level2),Product,Level2) for your "Level2 dimension" ?

Hierarchy pivot table

Wed, 07 Oct 2009 22:58:33 GMT

Yes, but then I still have 5 or 6 levels following after that dimension. I'll have to use calculated dim for all those hierarchy dimensions to try to make this pivot look nice.

Hierarchy pivot table

Wed, 14 Oct 2009 23:20:07 GMT

Sorry for the delay, you can have a look at NullasValue in the guide, maybe this will help you to avoid a lot of IF features ?

Hierarchy pivot table

Wed, 14 Oct 2009 23:29:29 GMT

I don't think is possible as a pivot chart must have a static amount of dimensions for all its values. An organizational chart/tree type object would be the perfect example for this, but QV doesn't have one (YET I hope)

Hierarchy pivot table

Mon, 09 Nov 2009 18:54:11 GMT

Hi Marko,

I saw attached qv file shared by you. I got the result also but I have one doubt.

Can you show count of categories under one another....like in your example 2 CategoryName2 are there under A and 1 under C.

Hierarchy pivot table

amien — Wed, 05 Jan 2011 23:35:30 GMT

whats the solution for this?

Re: Hierarchy pivot table

brindlogcool — Tue, 03 Jul 2012 13:41:57 GMT

Hi,

Did u got any solution??

Re: Hierarchy pivot table

jeffmartins — Tue, 17 Jul 2012 20:39:24 GMT

Hi,

I don't know if this solve your problem. I changed the expression and checked "show partial sum" option on presentation tab.

The pivot table looks nicer although the "show partial sum" option put a total in almost all lines of the pivot table. See the attached file.

Regards