Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
aetingu12
Creator
Creator

Keeping Select Possible for a field from within expression

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.

1.PNG2.PNG

 

Any help is more than appreciated.

Regards,

Aksel

Labels (3)
1 Solution

Accepted Solutions
marcus_sommer
MVP & Luminary
MVP & Luminary

You could try an expression like:

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

- Marcus

View solution in original post

1 Reply
marcus_sommer
MVP & Luminary
MVP & Luminary

You could try an expression like:

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

- Marcus