topic How best to load and visualize multiple level hierarchy in QV in QlikView

How best to load and visualize multiple level hierarchy in QV

Mon, 28 Sep 2009 21:44:02 GMT

Hi There

I have a hierarchy table with the usual parent key, child key structure. Just 2 things i need assistance on.

1. Am i correct in assuming the hierarchy function is the best way to load the multipel level hierarchy in the QV script.

2. What is the best way to visualize this in desinger mode ? In other words to expand ifinitely into the hierarchy and easily identify how many parent levels any given key has ?

Thanx

How best to load and visualize multiple level hierarchy in QV

johnw — Tue, 29 Sep 2009 00:36:42 GMT

It sounds like you want a pivot table with all of the levels of the hierarchy as dimensions. If so, then a hierarchy load is probably the most appropriate. Here is a trivial example to give you the idea.

How best to load and visualize multiple level hierarchy in QV

Anonymous — Thu, 31 May 2012 15:02:50 GMT

Hello,

I'm studying the Hierarchy prefix and I was wondering if you have some examples a little bit more explained and a little bit more complex?

Thanks

Re: How best to load and visualize multiple level hierarchy in QV

brindlogcool — Sun, 24 Jun 2012 14:43:41 GMT

Hi John,

I have gone through your QVW file. How to handle if the Level is mapped to Level 2 directly and i want the level 1 as blank between the level and level 2.