topic Re: Dynamic Hierarchies in Pivot Table in QlikView

Dynamic Hierarchies in Pivot Table

manishnarang — Wed, 15 Jul 2015 07:48:47 GMT

Hi Experts,

I have a question regarding Dynamic Org Hierarchy.

Say, we want to show Sum(Sales) in the Pivot Table for complete Employee hierarchy. We can do it using Hierarchy Load statement, and add all the columns created for levels by this load statement.

1. When employees from the leaf nodes move out of the company and org hierarchy gets one level lesser. The deepest level column is not created by Load statement and it is disabled in Pivot automatically. Fine.

2. But when leaf node employees also get some subordinates over time and org hierarchy gets expanded to one more level now. Can we do something that this gets added in Pivot automatically ?

Hope i was able to explain the scenario.

looking forward to expert suggestions..

Regards, Manish Narang

Re: Dynamic Hierarchies in Pivot Table

Gysbert_Wassenaar — Wed, 15 Jul 2015 08:11:05 GMT

2. No. Your script can create new fields automatically using the Hierarchy function. But Qlikview cannot read your mind so it has no idea that you might want to add the new fields to a specific pivot table. Only you have the knowledge that a specific field should be added in a specific position in a specific sheet object.

Re: Dynamic Hierarchies in Pivot Table

manishnarang — Wed, 15 Jul 2015 08:25:45 GMT

Hi Gysbert,

Agreed Sir. It can't read my mind.

But was just looking for a cleaner work around, just for Pivot table.

Although, i have achived this using Calculated dimensions in Pivot and enable/disable condition based on the max(depth) available in the dashboard.

It does work fine. But in a sense, it is again fixed to n levels, not completely dynamic.

best regards,,

Manish