topic Re: Switch Satement in EditScript in QlikView https://community.qlik.com/t5/QlikView/Switch-Satement-in-EditScript/m-p/856425#M659459 <HTML><HEAD></HEAD><BODY><P>Write the If statement on the same line as Switch</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #008000;">SWITCH&nbsp; </SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #008000;">IF(WEEKEND(DATE(QVDCREATETIME('C:\Users\ABC\Lastweekque.qvd'))) = DATE(WEEKEND(TODAY())),1,2)</SPAN></P></BODY></HTML> Mon, 06 Apr 2015 05:32:52 GMT anbu1984 2015-04-06T05:32:52Z Switch Satement in EditScript https://community.qlik.com/t5/QlikView/Switch-Satement-in-EditScript/m-p/856422#M659456 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I am trying to execute the load and store statement only if the day is Sunday. If it is Sunday and if the table is already stored then it should not run. Can somebody help me with my code. What is wrong in my Switch Statement.</P><P></P><P>Thanks in advance.</P><P><SPAN style="color: #008000;">SWITCH</SPAN></P><P></P><P><SPAN style="color: #008000;">IF(WEEKEND(DATE(QVDCREATETIME('C:\Users\ABC\Lastweekque.qvd'))) = DATE(WEEKEND(TODAY())),1,2)</SPAN></P><P></P><P><SPAN style="color: #008000;">CASE 1</SPAN></P><P><SPAN style="color: #008000;">TRACE('LAST WEEK QUE QVD IS ALREADY UPDATED');</SPAN></P><P></P><P><SPAN style="color: #008000;">CASE 2</SPAN></P><P><SPAN style="color: #008000;">Currweekque:</SPAN></P><P><SPAN style="color: #008000;">LOAD*FROM Lastweekque.qvd(qvd)</SPAN></P><P><SPAN style="color: #008000;">WHERE Uni_ReloadWeek &gt; DATE(WEEKEND(TODAY())-21);</SPAN></P><P><SPAN style="color: #008000;">CONCATENATE</SPAN></P><P><SPAN style="color: #008000;">LOAD</SPAN></P><P><SPAN style="color: #008000;">WEEKEND(TODAY()) AS Uni_ReloadWeek,</SPAN></P><P><SPAN style="color: #008000;">wa_Include_Roots AS Uni_Include_Roots,</SPAN></P><P><SPAN style="color: #008000;">RecID AS Uni_RecID</SPAN></P><P><SPAN style="color: #008000;">FROM RAITS;</SPAN></P><P></P><P><SPAN style="color: #008000;">STORE Currweekque INTO Lastweekque.QVD(QVD);</SPAN></P><P></P><P><SPAN style="color: #008000;">ENDSWITCH</SPAN></P><P><IMG alt="IMG_0575 (1).JPG" class="jive-image image-1" src="/legacyfs/online/82890_IMG_0575 (1).JPG" style="height: 465px; width: 620px;" /></P></BODY></HTML> Sun, 05 Apr 2015 22:10:49 GMT https://community.qlik.com/t5/QlikView/Switch-Satement-in-EditScript/m-p/856422#M659456 2015-04-05T22:10:49Z Re: Switch Satement in EditScript https://community.qlik.com/t5/QlikView/Switch-Satement-in-EditScript/m-p/856423#M659457 <HTML><HEAD></HEAD><BODY><P>------</P></BODY></HTML> Sun, 05 Apr 2015 23:20:38 GMT https://community.qlik.com/t5/QlikView/Switch-Satement-in-EditScript/m-p/856423#M659457 2015-04-05T23:20:38Z Re: Switch Satement in EditScript https://community.qlik.com/t5/QlikView/Switch-Satement-in-EditScript/m-p/856424#M659458 <HTML><HEAD></HEAD><BODY><P>----</P></BODY></HTML> Mon, 06 Apr 2015 02:19:00 GMT https://community.qlik.com/t5/QlikView/Switch-Satement-in-EditScript/m-p/856424#M659458 2015-04-06T02:19:00Z Re: Switch Satement in EditScript https://community.qlik.com/t5/QlikView/Switch-Satement-in-EditScript/m-p/856425#M659459 <HTML><HEAD></HEAD><BODY><P>Write the If statement on the same line as Switch</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #008000;">SWITCH&nbsp; </SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #008000;">IF(WEEKEND(DATE(QVDCREATETIME('C:\Users\ABC\Lastweekque.qvd'))) = DATE(WEEKEND(TODAY())),1,2)</SPAN></P></BODY></HTML> Mon, 06 Apr 2015 05:32:52 GMT https://community.qlik.com/t5/QlikView/Switch-Satement-in-EditScript/m-p/856425#M659459 anbu1984 2015-04-06T05:32:52Z