topic DATA SELECTION in QlikView https://community.qlik.com/t5/QlikView/DATA-SELECTION/m-p/263182#M1188664 <HTML><HEAD></HEAD><BODY><P>The easiest way would be to create a list box and sort your product list in by state in descending.&nbsp; 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.</P></BODY></HTML> Wed, 10 Aug 2011 19:27:47 GMT jdf 2011-08-10T19:27:47Z DATA SELECTION https://community.qlik.com/t5/QlikView/DATA-SELECTION/m-p/263181#M1188663 <HTML><HEAD></HEAD><BODY><P>Hi, i would like to know what my dealers are NOT buying in my product list rather than what they bought. Can you help ? </P></BODY></HTML> Wed, 10 Aug 2011 14:14:34 GMT https://community.qlik.com/t5/QlikView/DATA-SELECTION/m-p/263181#M1188663 2011-08-10T14:14:34Z DATA SELECTION https://community.qlik.com/t5/QlikView/DATA-SELECTION/m-p/263182#M1188664 <HTML><HEAD></HEAD><BODY><P>The easiest way would be to create a list box and sort your product list in by state in descending.&nbsp; 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.</P></BODY></HTML> Wed, 10 Aug 2011 19:27:47 GMT https://community.qlik.com/t5/QlikView/DATA-SELECTION/m-p/263182#M1188664 jdf 2011-08-10T19:27:47Z DATA SELECTION https://community.qlik.com/t5/QlikView/DATA-SELECTION/m-p/263183#M1188665 <HTML><HEAD></HEAD><BODY><P>Take a look at the Set Analysis E() modifier. </P><P></P><P>-Rob</P></BODY></HTML> Wed, 10 Aug 2011 22:54:53 GMT https://community.qlik.com/t5/QlikView/DATA-SELECTION/m-p/263183#M1188665 rwunderlich 2011-08-10T22:54:53Z