topic Re: Where condition in direct discovery in QlikView https://community.qlik.com/t5/QlikView/Where-condition-in-direct-discovery/m-p/595615#M220624 <HTML><HEAD></HEAD><BODY><P>Hi Rohit</P><P></P><P>This document may be useful</P><P></P><P></P><P><A href="https://community.qlik.com/docs/DOC-3710">QlikView 11 2 SR5 Direct Discovery Technical Addendum.pdf</A></P><P></P><P>regards</P><P>Darek</P></BODY></HTML> Mon, 05 May 2014 11:34:30 GMT 2014-05-05T11:34:30Z Where condition in direct discovery https://community.qlik.com/t5/QlikView/Where-condition-in-direct-discovery/m-p/595614#M220623 <HTML><HEAD></HEAD><BODY><P>hello ,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; i need to add where condition in direct discovery table ,how can i do that? i want to restrict my direct discovered table for 1 month value ?</P></BODY></HTML> Mon, 05 May 2014 11:12:22 GMT https://community.qlik.com/t5/QlikView/Where-condition-in-direct-discovery/m-p/595614#M220623 2014-05-05T11:12:22Z Re: Where condition in direct discovery https://community.qlik.com/t5/QlikView/Where-condition-in-direct-discovery/m-p/595615#M220624 <HTML><HEAD></HEAD><BODY><P>Hi Rohit</P><P></P><P>This document may be useful</P><P></P><P></P><P><A href="https://community.qlik.com/docs/DOC-3710">QlikView 11 2 SR5 Direct Discovery Technical Addendum.pdf</A></P><P></P><P>regards</P><P>Darek</P></BODY></HTML> Mon, 05 May 2014 11:34:30 GMT https://community.qlik.com/t5/QlikView/Where-condition-in-direct-discovery/m-p/595615#M220624 2014-05-05T11:34:30Z Re: Where condition in direct discovery https://community.qlik.com/t5/QlikView/Where-condition-in-direct-discovery/m-p/595616#M220625 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Make sure that you are using Qlikview 11.2 sr5 or grater.</P><P></P><P>Please find the attached document that will guide you how to achieve this.</P><P></P><P>Hope it helps.</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Mon, 05 May 2014 11:36:41 GMT https://community.qlik.com/t5/QlikView/Where-condition-in-direct-discovery/m-p/595616#M220625 ashfaq_haseeb 2014-05-05T11:36:41Z Re: Where condition in direct discovery https://community.qlik.com/t5/QlikView/Where-condition-in-direct-discovery/m-p/595617#M220626 <HTML><HEAD></HEAD><BODY><P>Just add a where in the load:</P><P></P><P>DIRECT QUERY </P><P>DIMENSION</P><P><SPAN style="font-size: 10pt;">...</SPAN></P><P><SPAN style="font-size: 10pt;">MEASURE</SPAN></P><P><SPAN style="font-size: 10pt;">...</SPAN></P><P><SPAN style="font-size: 10pt;">DETAIL</SPAN></P><P><SPAN style="font-size: 10pt;">...<BR /></SPAN></P><P><SPAN style="font-size: 10pt;">FROM ...</SPAN></P><P><SPAN style="font-size: 10pt;">LEFT JOIN ...</SPAN></P><P><SPAN style="font-size: 10pt;">WHERE ...</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">If you have an Where FieldA IN (1,2).. put it at last, because for some reason Qlikview just "cut" the SQL code after an IN.</SPAN></P><P><SPAN style="font-size: 10pt;">Remember you need to use the full name of tables/fields, without Alias.</SPAN></P><P><SPAN style="font-size: 10pt;">a.Field1=100 WRONG</SPAN></P><P><SPAN style="font-size: 10pt;">Database.Table.Field1=100 CORRECT<BR /></SPAN></P></BODY></HTML> Mon, 01 Oct 2018 17:36:41 GMT https://community.qlik.com/t5/QlikView/Where-condition-in-direct-discovery/m-p/595617#M220626 cristian_av 2018-10-01T17:36:41Z