topic Re: How to use Function &quot; Where &quot; ????? in QlikView https://community.qlik.com/t5/QlikView/How-to-use-Function-quot-Where-quot/m-p/1366610#M831034 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt;">You can do with it</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">Sample:<BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>Load * from Qvd Where Month = 'April';</STRONG></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>Store Sample into Path\Sample_April.qvd (qvd);<BR /></STRONG></SPAN></P></BODY></HTML> Wed, 14 Jun 2017 06:36:33 GMT Anil_Babu_Samineni 2017-06-14T06:36:33Z How to use Function " Where " ????? https://community.qlik.com/t5/QlikView/How-to-use-Function-quot-Where-quot/m-p/1366599#M831023 <HTML><HEAD></HEAD><BODY><P>Hi Dear friends</P><P>Please Help me<IMG src="https://community.qlik.com/legacyfs/online/emoticons/confused.png" /></P><P>How to use Function "Where"in edit script If Read data from database ( SQL)&nbsp;&nbsp; ?????</P><P>see attachment please</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-use-Function-quot-Where-quot/m-p/1366599#M831023 fgolmahi 2020-11-25T16:16:04Z Re: How to use Function " Where " ????? https://community.qlik.com/t5/QlikView/How-to-use-Function-quot-Where-quot/m-p/1366600#M831024 <HTML><HEAD></HEAD><BODY><P>You can use before semi colon only</P><P></P><P>Load * from Qvd Where Condition;</P></BODY></HTML> Wed, 14 Jun 2017 06:16:01 GMT https://community.qlik.com/t5/QlikView/How-to-use-Function-quot-Where-quot/m-p/1366600#M831024 Anil_Babu_Samineni 2017-06-14T06:16:01Z Re: Hi Dear Friend Please help me, How to use Function " Where " in edit script If Read data from database ( SQL) ????? https://community.qlik.com/t5/QlikView/How-to-use-Function-quot-Where-quot/m-p/1366601#M831025 <HTML><HEAD></HEAD><BODY><P>Put the Where condition after <STRONG>(qvd)</STRONG> and before <STRONG>;</STRONG></P><P><STRONG><BR /></STRONG></P><P>Load</P><P>&nbsp;&nbsp;&nbsp; a,</P><P>&nbsp;&nbsp;&nbsp; b,</P><P>&nbsp;&nbsp;&nbsp; c</P><P>from MyQvd.qvd (qvd) <STRONG>where CONDITIONS</STRONG> ;</P><P></P><P></P><P><A href="http://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Where_Clause.htm" title="http://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Where_Clause.htm">Where Clause ‒ QlikView</A></P><P><A href="https://community.qlik.com/videos/4112"> Video Link : 4112</A></P></BODY></HTML> Wed, 14 Jun 2017 06:16:48 GMT https://community.qlik.com/t5/QlikView/How-to-use-Function-quot-Where-quot/m-p/1366601#M831025 micheledenardi 2017-06-14T06:16:48Z Re: Hi Dear Friend Please help me, How to use Function " Where " in edit script If Read data from database ( SQL) ????? https://community.qlik.com/t5/QlikView/How-to-use-Function-quot-Where-quot/m-p/1366602#M831026 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>try like below </P><P></P><P><STRONG>Fact:</STRONG></P><P>LOAD </P><P>Table_Columns;</P><P>SQL SELECT *</P><P>FROM [SQL table name]</P><P>Where Condition = value;</P><P></P><P>STORE Fact into $(vQVDPath)\Fact.QVD;</P></BODY></HTML> Wed, 14 Jun 2017 06:18:56 GMT https://community.qlik.com/t5/QlikView/How-to-use-Function-quot-Where-quot/m-p/1366602#M831026 devarasu07 2017-06-14T06:18:56Z Re: How to use Function " Where " ????? https://community.qlik.com/t5/QlikView/How-to-use-Function-quot-Where-quot/m-p/1366603#M831027 <HTML><HEAD></HEAD><BODY><P>Remove colon..</P><P></P><P></P><P><IMG alt="Untitled.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/166778_Untitled.png" style="height: auto;" /></P></BODY></HTML> Wed, 14 Jun 2017 06:20:07 GMT https://community.qlik.com/t5/QlikView/How-to-use-Function-quot-Where-quot/m-p/1366603#M831027 prma7799 2017-06-14T06:20:07Z Re: How to use Function " Where " ????? https://community.qlik.com/t5/QlikView/How-to-use-Function-quot-Where-quot/m-p/1366604#M831028 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">colon means end of the statement</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Use colon (;)&nbsp; after your last code of the script ...</P></BODY></HTML> Wed, 14 Jun 2017 06:20:41 GMT https://community.qlik.com/t5/QlikView/How-to-use-Function-quot-Where-quot/m-p/1366604#M831028 prma7799 2017-06-14T06:20:41Z Re: How to use Function " Where " ????? https://community.qlik.com/t5/QlikView/How-to-use-Function-quot-Where-quot/m-p/1366605#M831029 <HTML><HEAD></HEAD><BODY><P><IMG alt="1111.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/166779_1111.png" style="height: 350px; width: 620px;" /></P></BODY></HTML> Wed, 14 Jun 2017 06:24:06 GMT https://community.qlik.com/t5/QlikView/How-to-use-Function-quot-Where-quot/m-p/1366605#M831029 fgolmahi 2017-06-14T06:24:06Z Re: How to use Function " Where " ????? https://community.qlik.com/t5/QlikView/How-to-use-Function-quot-Where-quot/m-p/1366606#M831030 <HTML><HEAD></HEAD><BODY><P>thanks Dear</P><P>Is that not work <IMG alt="1111.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/166780_1111.png" style="height: 350px; width: 620px;" /></P></BODY></HTML> Wed, 14 Jun 2017 06:29:35 GMT https://community.qlik.com/t5/QlikView/How-to-use-Function-quot-Where-quot/m-p/1366606#M831030 fgolmahi 2017-06-14T06:29:35Z Re: How to use Function   " Where "   ????? https://community.qlik.com/t5/QlikView/How-to-use-Function-quot-Where-quot/m-p/1366607#M831031 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Refer below screen, </P><P><IMG alt="Untitled.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/166785_Untitled.png" style="height: auto;" /></P></BODY></HTML> Wed, 14 Jun 2017 06:34:00 GMT https://community.qlik.com/t5/QlikView/How-to-use-Function-quot-Where-quot/m-p/1366607#M831031 devarasu07 2017-06-14T06:34:00Z Re: How to use Function " Where " ????? https://community.qlik.com/t5/QlikView/How-to-use-Function-quot-Where-quot/m-p/1366608#M831032 <HTML><HEAD></HEAD><BODY><P>Thanks Dear</P><P>Don't work it<IMG src="https://community.qlik.com/legacyfs/online/emoticons/confused.png" /></P><P>please help me</P></BODY></HTML> Wed, 14 Jun 2017 06:34:45 GMT https://community.qlik.com/t5/QlikView/How-to-use-Function-quot-Where-quot/m-p/1366608#M831032 fgolmahi 2017-06-14T06:34:45Z Re: How to use Function " Where " ????? https://community.qlik.com/t5/QlikView/How-to-use-Function-quot-Where-quot/m-p/1366609#M831033 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Remove the Semicolon&nbsp; to the store statement (After Qvd) then write the where condition </P></BODY></HTML> Wed, 14 Jun 2017 06:35:11 GMT https://community.qlik.com/t5/QlikView/How-to-use-Function-quot-Where-quot/m-p/1366609#M831033 prabhas277 2017-06-14T06:35:11Z Re: How to use Function " Where " ????? https://community.qlik.com/t5/QlikView/How-to-use-Function-quot-Where-quot/m-p/1366610#M831034 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt;">You can do with it</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">Sample:<BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>Load * from Qvd Where Month = 'April';</STRONG></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>Store Sample into Path\Sample_April.qvd (qvd);<BR /></STRONG></SPAN></P></BODY></HTML> Wed, 14 Jun 2017 06:36:33 GMT https://community.qlik.com/t5/QlikView/How-to-use-Function-quot-Where-quot/m-p/1366610#M831034 Anil_Babu_Samineni 2017-06-14T06:36:33Z Re: How to use Function " Where " ????? https://community.qlik.com/t5/QlikView/How-to-use-Function-quot-Where-quot/m-p/1366611#M831035 <HTML><HEAD></HEAD><BODY><P><IMG alt="1111.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/166787_1111.png" style="height: 350px; width: 620px;" /></P><P>please help me <IMG src="https://community.qlik.com/legacyfs/online/emoticons/plain.png" /></P></BODY></HTML> Wed, 14 Jun 2017 06:42:59 GMT https://community.qlik.com/t5/QlikView/How-to-use-Function-quot-Where-quot/m-p/1366611#M831035 fgolmahi 2017-06-14T06:42:59Z Re: How to use Function " Where " ????? https://community.qlik.com/t5/QlikView/How-to-use-Function-quot-Where-quot/m-p/1366612#M831036 <HTML><HEAD></HEAD><BODY><P>Hi Fatemeh,</P><P>You can use Debug option in Qlikview load script.</P><P>The issue you raised is syntactical error. Please paste your code so that we can help.</P><P></P><P>Regards,</P><P>Pankaj</P></BODY></HTML> Wed, 14 Jun 2017 06:43:48 GMT https://community.qlik.com/t5/QlikView/How-to-use-Function-quot-Where-quot/m-p/1366612#M831036 passionate 2017-06-14T06:43:48Z Re: How to use Function " Where " ????? https://community.qlik.com/t5/QlikView/How-to-use-Function-quot-Where-quot/m-p/1366613#M831037 <HTML><HEAD></HEAD><BODY><P>SQL Doesn't make Blue color because Qlik is not the SQL engine. It will work. And that you need to load then check whether qvd stores the condition respect data</P></BODY></HTML> Wed, 14 Jun 2017 06:45:26 GMT https://community.qlik.com/t5/QlikView/How-to-use-Function-quot-Where-quot/m-p/1366613#M831037 Anil_Babu_Samineni 2017-06-14T06:45:26Z Re: How to use Function " Where " ????? https://community.qlik.com/t5/QlikView/How-to-use-Function-quot-Where-quot/m-p/1366614#M831038 <HTML><HEAD></HEAD><BODY><P><IMG alt="1111.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/166788_1111.png" style="height: 300px; width: 620px;" /> </P><P>thanks but not correct<IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P></BODY></HTML> Wed, 14 Jun 2017 06:46:08 GMT https://community.qlik.com/t5/QlikView/How-to-use-Function-quot-Where-quot/m-p/1366614#M831038 fgolmahi 2017-06-14T06:46:08Z Re: How to use Function " Where " ????? https://community.qlik.com/t5/QlikView/How-to-use-Function-quot-Where-quot/m-p/1366615#M831039 <HTML><HEAD></HEAD><BODY><P>SQL Select&nbsp; AdmCode,</P><P>IcdCode,</P><P>GICDDate,</P><P>GICDName,</P><P>GICDNote,</P><P>GICDPersCode,</P><P>GICDStatus,</P><P>GICDStatusName,</P><P>GICDType</P><P>From Shafa.dbo"GiveICD_QlickView"</P><P>where "Put your condition here";</P><P></P><P>STORE cod into cod.qvd(qvd);</P></BODY></HTML> Wed, 14 Jun 2017 06:46:58 GMT https://community.qlik.com/t5/QlikView/How-to-use-Function-quot-Where-quot/m-p/1366615#M831039 prma7799 2017-06-14T06:46:58Z Re: How to use Function " Where " ????? https://community.qlik.com/t5/QlikView/How-to-use-Function-quot-Where-quot/m-p/1366616#M831040 <HTML><HEAD></HEAD><BODY><P><IMG alt="IMG_6419.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/166789_IMG_6419.JPG" style="height: 518px; width: 620px;" /></P><P>error in debug <IMG src="https://community.qlik.com/legacyfs/online/emoticons/confused.png" /></P></BODY></HTML> Wed, 14 Jun 2017 07:14:33 GMT https://community.qlik.com/t5/QlikView/How-to-use-Function-quot-Where-quot/m-p/1366616#M831040 fgolmahi 2017-06-14T07:14:33Z Re: How to use Function " Where " ????? https://community.qlik.com/t5/QlikView/How-to-use-Function-quot-Where-quot/m-p/1366617#M831041 <HTML><HEAD></HEAD><BODY><P><IMG alt="IMG_6419.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/166793_IMG_6419.JPG" style="height: 518px; width: 620px;" /></P><P>don't correct<IMG src="https://community.qlik.com/legacyfs/online/emoticons/cry.png" /></P></BODY></HTML> Wed, 14 Jun 2017 07:16:01 GMT https://community.qlik.com/t5/QlikView/How-to-use-Function-quot-Where-quot/m-p/1366617#M831041 fgolmahi 2017-06-14T07:16:01Z Re: How to use Function " Where " ????? https://community.qlik.com/t5/QlikView/How-to-use-Function-quot-Where-quot/m-p/1366618#M831042 <HTML><HEAD></HEAD><BODY><P>Please share that script ...</P></BODY></HTML> Wed, 14 Jun 2017 07:20:22 GMT https://community.qlik.com/t5/QlikView/How-to-use-Function-quot-Where-quot/m-p/1366618#M831042 prma7799 2017-06-14T07:20:22Z