Keeping Select Possible for a field from within expression

[aetingu12]

Dear all,

I am doing an analysis on some data that requires me to keep a certain field static (all possible selected) while I change select another field.

Here is an example with the bike equipment database from qlikview:

I have a pivot table with Date, Product and Sales.  If I filter on one product "AWC Logo Cap", I end up with 4 customers who has bought that product.  What  I need is to keep those customers static and bring in all of the products these 4 had bought.

I hope that makes sense.

Any help is more than appreciated.

Regards,

Aksel

[marcus_sommer · Accepted solution]

You could try an expression like:

sum({< Customer = p(Customer), Product >} Sales)

- Marcus