Keeping Select Possible for a field from within expression

aetingu12 — Sat, 16 Nov 2024 18:49:23 GMT

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

Re: Keeping Select Possible for a field from within expression

marcus_sommer — Wed, 08 Apr 2020 14:16:42 GMT

You could try an expression like:

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

- Marcus

topic Keeping Select Possible for a field from within expression in QlikView

Keeping Select Possible for a field from within expression

Re: Keeping Select Possible for a field from within expression