How to create a hierarchy in QV 8.5

[#1]

Hello togehter,

at fisrt, sorry for my bad englisch. I trie to create a hierarchy out of SAP data. I get the data like this ... SAP table

column_1;column_2; W0001;text1; W0002;text2; W0003;text3; W000100001;text4; W000100002;text5; W000200001;text6;

and so on. I tried anythink I found into the internet, but it will not work. I get the folowing QV output, but "level 2" and "level 3" will not marked if I klick a "level 1" entry. Here is my code... hierarchy_prod.qvw

[Product]: HIERARCHY (Level_1,Level_2,Level_3) Load If(Len(PRODH) =5, PRODH) as Level_1, If(Len(PRODH) =10, PRODH) as Level_2, If(Len(PRODH) >10, PRODH) as Level_3, VTEXT ; SQL SELECT * FROM T179T ;

[pdumas]

Hi Florian

I started Hierarchies by spending some hours understanding the tutorial on the forum and adapting the code to my data

http://community.qlik.com/media/p/61388.aspx

Hope this helps.

The examples are for QV8. With QV9 it becomes simpler

Pierre.

[#3]

No, sorry. It will not work. I have no more ideas. I don't know, how explain you my purposes. Some other ideas, please.

[pdumas]

I would try something like

ParentChild:
load column_1,
column_2,
right(column_1,5) as Child,
left(right(column_1,10),5) as Parent
resident T179T;

then you have a standard QlikView "Parent Child" hierarchy

Pierre.

[#5]

TKS Dumas, I was found the same problem here!

BUT, the Hierarquies are ON now!

I´m loading from ECC 6.0!!!

See ya!