Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Filtering dimension based on another field

I don't know if i have phrased my question correct or not. here are the details

I have a data set which gives the sales by salesperson for a product and the customer who buys it

another data set which gives all the customers by salesperson

what i am trying to do is when a product is selected in the listbox, i want to display 2 lists

1. Customers buying that product

2. Customers not buying that product

1st one is simple, but i cannot figure out a way to do the second. please help.

1 Solution

Accepted Solutions
sunny_talwar

Isn't this what you want?

Capture.PNG

Attaching the sample for you to play around with

Best,

Sunny

View solution in original post

4 Replies
sunny_talwar

May be like this:

1) Concat({<Cust_ID = P({<product = p(product)>})>} Customers, ', ')

2) Concat({<Cust_ID = E({<product = p(product)>}), product>} Customers, ', ')

Not applicable
Author

Could you elaborate.

i have added the screenshot of the scenario just to be clear.

please note that data set 1 only gets the customers where sales have been made, whereas data set 2 has all the customers.Exclusion.png

sunny_talwar

Isn't this what you want?

Capture.PNG

Attaching the sample for you to play around with

Best,

Sunny

Not applicable
Author

Thanks a lot