topic Complex hierarchy design in QlikView

Complex hierarchy design

Wed, 20 Jan 2010 11:27:40 GMT

Hi, this appears quite difficult to solve, I was hoping someone could help, if anyone can it would be much appreciated. I want to create a tree view list box for three columns of data, however I cannot work out how to get the load hierarchy correct.

The data I have is this:

Top level are cost centres: 1914400,1914200,1914403 etc etc

These then open up into a group level: OHD's and Labour

Once you open either OHD's or Labour you are presented with a list of Object Accounts

The problem is that the same Object accounts and OHD's and labour appear for every cost centre, how do I script a hierarchy load to take this into account?

Having spoken to one of the qlikview tutors they have suggested doing the hierarchy in two stages with the first one joining the cost centre and Groups, then concatonating the path with the hierarchy of object accounts. I am however a little confused by this, can anyone help please? If you could upload any QVWs that might give a hint it would be much appreciated. I have uploaded two excel files, one with all the cost centres and one with the group and object account combinations.

I hope this makes some sense

Cheers

Ben

Complex hierarchy design

Wed, 20 Jan 2010 11:34:40 GMT

Here are the cost centres

Complex hierarchy design

Wed, 20 Jan 2010 12:11:51 GMT

Hi,

I tried to solve your problem. I attached the QV with my solution.

Hope I understood your problem right and this will help you.

Milda

Complex hierarchy design

Wed, 20 Jan 2010 12:33:29 GMT

Thanks very much, that is indeed what I wanted!

Complex hierarchy design

wizardo — Tue, 09 Mar 2010 01:24:17 GMT

hi,

iv trie using similiar design for a treview

the prblem is that if used this way then the user can only select the "leafs" of the tree (EG when you expand a node all the way)

but if you click on a parent node it will not select the children nodes

so its probebly only useful if the user only needs to select the leafs (EG an account number ).

in my case i have a flat hirarchy with each level on its own field (its the same as the result of the hierarchy command)

but i need to be able to select each level and have it select all lower levels so this solution is not good

any ideas?

MAnsyno