Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
pnutbutta
Contributor II
Contributor II

Refining selection with P()

I would like a measure to only show results using the P() expression but add another level of criteria and I'm not sure the best way to include this.

Right now I'm showing customers that purchase product 1022:

sum( {$<CustomerName = P({1<Product={'1022'}>})>} Qty )

I would like to add another refinement to only bring in results for customers that purchase product 1022 and show the other products that these customers have purchased. But I don't want to include results for all products. I think the easiest way to do this is exclude the product families I don't want included in results, example 50, 52, 54, 58. This is referred in the data as "Pack".

So my ideal result is customers that purchase product 1022 and then show the other products that this customer group has purchased not including results from Pack 50,52,54,58.

This will be shown in a Pivot Table ideally.

Any guidance would be appreciated!

1 Solution

Accepted Solutions
petter
MVP
MVP

It should be this:

Sum( {$< CustomerName = P({1<Product={1022}>}) , Pack -= {50,52,54,58} >} Qty )

View solution in original post

1 Reply
petter
MVP
MVP

It should be this:

Sum( {$< CustomerName = P({1<Product={1022}>}) , Pack -= {50,52,54,58} >} Qty )

View solution in original post