Hierarchy pivot table

[#1]

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

[#2]

You could maybe try with calculated dimensions such as

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

[#3]

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.

[#4]

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 ?

[#5]

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)

[#6]

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.

[amien]

whats the solution for this?

[brindlogcool]

Hi,

Did u got any solution??

[jeffmartins]

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