Hi, as you know perharps drill up/dow on non hierarchical dimensions (with many-to-many relationships) is possible in many big BI softwares using data modifications, mainly using composite keys in order to make the BI framework think he is using a hierarchy 🙂
Is it the same thing in Qlikview or it is possible no to use that BI trick ?
to illustrate a non hierachical drill imagine this
c1 c2
---- ----
A 1
A 2
B 1
B 3
C 1
Z 1
it is non hierarchical because ther is fields in c2 that have different fathers in c1 (eg. 1 as 4 fathers, A and B and C and Z)
drilling in this means
you see
A
B
C
Z
when u click (drill down) on A you get this
1
2
when u click (drill up) on 1 you get this
A
B
C
Z
thank u in advance
