Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Population based on SELECTION

I have a large population of PRODUCTS.

I want to click on a PRODUCT which happens to be made in JAPAN and is a TOY.

Is it possible for me to select just this PRODUCT in a chart / listbox and have another chart populate with ALL TOYS THAT ARE BOTH MADE IN JAPAN AND IS ALSO A TOY?

I'm thinking this may be a aggr(sum) type expression maybe using the 'p' function.

Thanks in ADVANCE!

1 Solution

Accepted Solutions
johnw
Champion III
Champion III

Sounds like they won't actually select TOY and JAPAN, though. Rather, they'll select a particular product, and want to see products of the same type in the same country. So I think this?

sum({<PRODUCT=,PRODUCT_TYPE=P(),COUNTRY=P()>} Amount)

View solution in original post

3 Replies
pover
Luminary Alumni
Luminary Alumni

In the other chart use set analysis to ignore the selection of product like the example below:

sum({$<PRODUCT=>} Amount)

That expression will still respect the selection of TOY and JAPAN.

Regards.

johnw
Champion III
Champion III

Sounds like they won't actually select TOY and JAPAN, though. Rather, they'll select a particular product, and want to see products of the same type in the same country. So I think this?

sum({<PRODUCT=,PRODUCT_TYPE=P(),COUNTRY=P()>} Amount)

Not applicable
Author

This worked perfectly. Thank you!