topic Exclude records with a list in QlikView https://community.qlik.com/t5/QlikView/Exclude-records-with-a-list/m-p/195599#M56031 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P>I have a document with serveral tabs. My idea for the last tab is to give an overview of settings, updates etc.</P><P>But most important, I have a list, with windows ticker-boxes, were I can select records (ID's). What I want, is to exclude these ID's which are selected for the document. I know this can be done by adding a where statement in the LOAD section of the script, but since this exclude-list changes every day, I want to make it very simple to change the excluded records.</P><P>Thanks in advance,</P><P>René</P></BODY></HTML> Wed, 23 Sep 2009 13:51:59 GMT 2009-09-23T13:51:59Z Exclude records with a list https://community.qlik.com/t5/QlikView/Exclude-records-with-a-list/m-p/195599#M56031 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P>I have a document with serveral tabs. My idea for the last tab is to give an overview of settings, updates etc.</P><P>But most important, I have a list, with windows ticker-boxes, were I can select records (ID's). What I want, is to exclude these ID's which are selected for the document. I know this can be done by adding a where statement in the LOAD section of the script, but since this exclude-list changes every day, I want to make it very simple to change the excluded records.</P><P>Thanks in advance,</P><P>René</P></BODY></HTML> Wed, 23 Sep 2009 13:51:59 GMT https://community.qlik.com/t5/QlikView/Exclude-records-with-a-list/m-p/195599#M56031 2009-09-23T13:51:59Z Exclude records with a list https://community.qlik.com/t5/QlikView/Exclude-records-with-a-list/m-p/195600#M56032 <HTML><HEAD></HEAD><BODY><P>Rene,</P><P>How about a spreadsheet that is loaded into the document and used in the where clause?</P><P>Regards,</P><P>Gordon</P></BODY></HTML> Wed, 23 Sep 2009 15:24:22 GMT https://community.qlik.com/t5/QlikView/Exclude-records-with-a-list/m-p/195600#M56032 2009-09-23T15:24:22Z Exclude records with a list https://community.qlik.com/t5/QlikView/Exclude-records-with-a-list/m-p/195601#M56033 <HTML><HEAD></HEAD><BODY><P>Thanks Gordon,</P><P>I'm considering it as one of the possibilities.</P><P>Rene</P></BODY></HTML> Wed, 23 Sep 2009 15:31:39 GMT https://community.qlik.com/t5/QlikView/Exclude-records-with-a-list/m-p/195601#M56033 2009-09-23T15:31:39Z