Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mellerbeck
Creator II
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
mellerbeck
Creator II
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.

View solution in original post

2 Replies
sunny_talwar

May be a set expression like this in your expression

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

mellerbeck
Creator II
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.