Skip to main content

# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save \$300 before February 6: REGISTER NOW!
cancel
Showing results for
Search instead for
Did you mean:
Creator II

## Set Analysis as a Calculated Dimension Displaying Possible

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!

1 Solution

Accepted Solutions
Creator II
Author

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.

2 Replies
MVP

May be a set expression like this in your expression

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

Creator II
Author

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.

Community Browser