topic Filtering dimension based on another field in QlikView

Filtering dimension based on another field

Tue, 14 Jun 2016 16:18:21 GMT

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.

sunny_talwar — Tue, 14 Jun 2016 16:23:15 GMT

May be like this:

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

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

Tue, 14 Jun 2016 17:21:11 GMT

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.

sunny_talwar — Tue, 14 Jun 2016 17:52:49 GMT

Isn't this what you want?

Attaching the sample for you to play around with

Best,

Sunny

Tue, 14 Jun 2016 18:23:27 GMT

Thanks a lot