topic Not in statement in QlikView

topic Not in statement in QlikView https://community.qlik.com/t5/QlikView/Not-in-statement/m-p/1529977#M443956 <P>Hi,</P><P> </P><P>I use the following a lot when selecting data from the SQL server:</P><P>SQL SELECT</P><P>FROM "Item Ledger Entry"</P><P><FONT color="#FF0000">Where  "Global Dimension 2 Code" not in ('CF');</FONT></P><P> </P><P><FONT color="#FF0000"><FONT color="#000000">I would like to use this same function when loading from a "Table File" but it seems not to be working.</FONT><BR /></FONT></P><P> </P><P><FONT color="#FF0000"><FONT color="#000000">What is the solution for this?</FONT></FONT></P><P> </P><P> </P><P> </P> Sat, 16 Nov 2024 04:46:03 GMT ranibosch 2024-11-16T04:46:03Z Not in statement https://community.qlik.com/t5/QlikView/Not-in-statement/m-p/1529977#M443956 <P>Hi,</P><P> </P><P>I use the following a lot when selecting data from the SQL server:</P><P>SQL SELECT</P><P>FROM "Item Ledger Entry"</P><P><FONT color="#FF0000">Where  "Global Dimension 2 Code" not in ('CF');</FONT></P><P> </P><P><FONT color="#FF0000"><FONT color="#000000">I would like to use this same function when loading from a "Table File" but it seems not to be working.</FONT><BR /></FONT></P><P> </P><P><FONT color="#FF0000"><FONT color="#000000">What is the solution for this?</FONT></FONT></P><P> </P><P> </P><P> </P> Sat, 16 Nov 2024 04:46:03 GMT https://community.qlik.com/t5/QlikView/Not-in-statement/m-p/1529977#M443956 ranibosch 2024-11-16T04:46:03Z Re: Not in statement https://community.qlik.com/t5/QlikView/Not-in-statement/m-p/1529995#M443957 <P>Look here</P><P><A href="https://community.qlik.com/t5/New-to-Qlik-Community/Not-in-statement/m-p/1529981/highlight/false#M8209" target="_blank">https://community.qlik.com/t5/New-to-Qlik-Community/Not-in-statement/m-p/1529981/highlight/false#M8209</A></P> Mon, 14 Jan 2019 12:55:40 GMT https://community.qlik.com/t5/QlikView/Not-in-statement/m-p/1529995#M443957 sunny_talwar 2019-01-14T12:55:40Z