how can i pivot this?

[amien]

what i want is as dimensions:

* all level1

* all level2,

* all level3,

... etc

and than as expression a SUM(VALUE)..

so i need to create dimensions.. help 🙂

LOAD * INLINE [
Level, Name, Value
1, text, 4
2, text, 6
2, text, 7
2, text ,8
3, text ,6
1, text, 6
2, text, 7
3, text, 8
3, text, 10
3, text, 15
1, text, 60
];

[disqr_rm]

Don't you have level 2 records connected to level 1 records somehow, like parent_row?

How a pivod should expand?

[amien]

thanks for your fast reply ..

yes .. i have parentid and nodeid..

pivot should expand by level number .. so first level0, expand .. then all level1 nodenames, then expand level2, all nodenames etc etc

i think i would need alot of level dimensions and 1 expression

[amien]

i found this on the forum:

http://community.qlik.com/forums/p/19682/75132.aspx#75132

this is basicly what i need (last example of John) .. but i cant transform it into my data layout..

i dont have rowno() .. no BOM_ID .. i could add my Ultimate Parent for each NodeID if needed..

i only have NodeID, NodeName and ParentID..

John?