topic Population based on SELECTION in QlikView

Population based on SELECTION

Tue, 30 Nov 2010 20:59:59 GMT

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!

Population based on SELECTION

pover — Tue, 30 Nov 2010 21:24:15 GMT

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.

Population based on SELECTION

johnw — Tue, 30 Nov 2010 23:01:55 GMT

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)

Population based on SELECTION

Tue, 30 Nov 2010 23:11:24 GMT

This worked perfectly. Thank you!