Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

DATA SELECTION

Hi, i would like to know what my dealers are NOT buying in my product list rather than what they bought. Can you help ?

2 Replies
Employee
Employee

DATA SELECTION

The easiest way would be to create a list box and sort your product list in by state in descending.  This way when you have a dealer selected the products that are not purchased by that dealer will be grayed out in the list box, by sorting the state in descending the not purchased products will be listed first.

DATA SELECTION

Take a look at the Set Analysis E() modifier.

-Rob

Community Browser