Keeping Select Possible for a field from within expression
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.