Discussion Board for collaboration related to QlikView App Development.
M stuck off facing this problem. here's an example
like i have a table
LOAD * INLINE [
I want output as alike hierarchy wise on basis of flag
so, in pivot i want this
Level1 Level2 Level3
A B C
here, when i expand A then it gives all data of Level2 and Level3
but when i expand Level2 F value it gives G and H in Level3
Any help will be appreciated.
Go to Solution.
Please see if the attached file helps you.
You might want to take a look at this article as well: Hierarchies
Please help me here i want
in three separate field
Level1 gives value A
level2 gives B and F
Level 3 gives C,D,E,F,G,H
here in level2 if i select B then in Level3 gives C,D,E
when i select F value in Level2 then it gives F,G,H
or if can't possible please suggest me how to make Correlated flag in data source so, that it can give like this output
HIERARCHY(NodeID, ParentID, Node)
Flag as NodeID,
Flag-1 as ParentID,
Name as Node;