Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

Re: Filtering dimension based on another field

Isn't this what you want?

Capture.PNG

Attaching the sample for you to play around with

Best,

Sunny

4 Replies

Re: Filtering dimension based on another field

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

Re: Filtering dimension based on another field

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

Re: Filtering dimension based on another field

Isn't this what you want?

Capture.PNG

Attaching the sample for you to play around with

Best,

Sunny

Not applicable

Re: Filtering dimension based on another field

Thanks a lot

Community Browser