Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

You could try an expression like:

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

- Marcus

View solution in original post

1 Reply
Highlighted
MVP & Luminary
MVP & Luminary

You could try an expression like:

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

- Marcus

View solution in original post