topic Re: Unbalanced ragged hierarchy question in QlikView

Unbalanced ragged hierarchy question

charlotte_qvw — Wed, 20 Nov 2013 16:39:03 GMT

I have a ragged hierarchy (thanks Henric for the terminology in your paper!) with different levels of data. It has City, Estate, Block and Unit. But not all units have a block. I attach a sample file. How can I use the hierarchy load to separate out the data and create fields called City, Estate, Block and Unit, depending on the Level Code? If I use the hierarchy load that I've used before I get my unit in 2 different fields for the 2 examples. For London, it goes in Address3, for Paris in Address4, because Paris has an extra level. However I would like it be in the same field, always, depending on the Level Code.

Many thanks

Charlotte

Re: Unbalanced ragged hierarchy question

hic — Wed, 20 Nov 2013 22:10:36 GMT

It can probably be done simpler, but here is one way to do it.

HIC

Re: Unbalanced ragged hierarchy question

charlotte_qvw — Wed, 20 Nov 2013 22:14:45 GMT

Thanks Henric, off to test out now!. Hope you're well.

Re: Unbalanced ragged hierarchy question

charlotte_qvw — Thu, 21 Nov 2013 11:13:25 GMT

Thanks Henric, very helpful indeed and adapted to my actual data has done the trick perfectly.

Re: Unbalanced ragged hierarchy question

Mon, 31 Mar 2014 14:31:47 GMT

Hi Henric,

I have a similar situation as Charlotte and I would like to make a drill down group (not cyclic).I have been reading your post about hierarchies, I am wondering how could I combine the unbalanced hierarchies example (Hierarchies) to get the grouping with ragged hierarchies?

Thanks in advance!

Ale