topic Re: Set Analysis as a Calculated Dimension Displaying Possible in QlikView

Set Analysis as a Calculated Dimension Displaying Possible

mellerbeck — Wed, 25 Nov 2020 16:16:04 GMT

Given

LOAD * INLINE [

Parent, Child

1, A

1, B

1, C

1, D

A, 2

A, 3

A, 4

A, 5

];

If Child A is selected, Parent 1 is possible. I would like a chart that can show that A is a parent as well and its children are 2,3,4,5.

Something like

=aggr(Only({<Parent=P(Child)>} Parent),Child)

But I haven't quite grokked it yet

Thanks for any thoughts on this one!

sunny_talwar — Sat, 21 Apr 2018 02:31:27 GMT

May be a set expression like this in your expression

{<Parent = p(Child), Child>+<Child = p(Child)>}

mellerbeck — Sat, 21 Apr 2018 05:42:13 GMT

I ended up adding a qty value to my test and then did Child as the Dimension and

=Sum({1<Parent=P(Child)>} qty) as the expression.