topic If else clause in the script of Qlikview <Script line error> in QlikView

topic If else clause in the script of Qlikview <Script line error> in QlikView https://community.qlik.com/t5/QlikView/If-else-clause-in-the-script-of-Qlikview-lt-Script-line-error-gt/m-p/1392727#M820053 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'm new to Qlikview, Could anyone help me in using a '<STRONG>if else</STRONG>' clause in the script level of Qlikview.</P><P></P><P>I want to run a SQL Query based on IF ELSE condition, the satisfied condition i want to save it in a qvd. I get a script line error as in the screen shots at IF and Else statement line. when clicked 'ok' in the error, both the SQL statements run and fetch data in Qlikview.</P><P>Example:</P><P>IF (weekday(today())='Sat')</P><P>SQL SELECT * FROM TABLE1;</P><P>ELSE</P><P>SQL SELECT * FROM TABLE2;</P><P></P><P style="font-size: 13.3333px;">Here is the SQL query used in the Mysql (SQL Server) Database.</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"><EM>if exists (select 1 WHERE datename(WEEKDAY,GETDATE())='Monday')</EM></P><P style="font-size: 13.3333px;"><EM>SELECT * FROM  TABLE1</EM></P><P style="font-size: 13.3333px;"><EM>else </EM></P><P style="font-size: 13.3333px;"><EM> SELECT * FROM  TABLE2</EM></P><P></P><P>Thanks for your help</P><P></P><P>Message was edited by: shyam kumar</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT shmkmr90 2020-11-25T16:16:04Z If else clause in the script of Qlikview <Script line error> https://community.qlik.com/t5/QlikView/If-else-clause-in-the-script-of-Qlikview-lt-Script-line-error-gt/m-p/1392727#M820053 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'm new to Qlikview, Could anyone help me in using a '<STRONG>if else</STRONG>' clause in the script level of Qlikview.</P><P></P><P>I want to run a SQL Query based on IF ELSE condition, the satisfied condition i want to save it in a qvd. I get a script line error as in the screen shots at IF and Else statement line. when clicked 'ok' in the error, both the SQL statements run and fetch data in Qlikview.</P><P>Example:</P><P>IF (weekday(today())='Sat')</P><P>SQL SELECT * FROM TABLE1;</P><P>ELSE</P><P>SQL SELECT * FROM TABLE2;</P><P></P><P style="font-size: 13.3333px;">Here is the SQL query used in the Mysql (SQL Server) Database.</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"><EM>if exists (select 1 WHERE datename(WEEKDAY,GETDATE())='Monday')</EM></P><P style="font-size: 13.3333px;"><EM>SELECT * FROM  TABLE1</EM></P><P style="font-size: 13.3333px;"><EM>else </EM></P><P style="font-size: 13.3333px;"><EM> SELECT * FROM  TABLE2</EM></P><P></P><P>Thanks for your help</P><P></P><P>Message was edited by: shyam kumar</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/If-else-clause-in-the-script-of-Qlikview-lt-Script-line-error-gt/m-p/1392727#M820053 shmkmr90 2020-11-25T16:16:04Z Re: If else clause in the script of Qlikview <Script line error> https://community.qlik.com/t5/QlikView/If-else-clause-in-the-script-of-Qlikview-lt-Script-line-error-gt/m-p/1392728#M820054 <HTML><HEAD></HEAD><BODY><P>I noticed a syntax error in the query which i shared earlier (Missed THEN in the example). But However when i give a table name and store it in a qvd, it is throwing an error.</P><P></P><P><EM><STRONG>Temp:</STRONG></EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM>IF (weekday(today())='Sat')</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM>SQL SELECT * FROM TABLE1;</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM>ELSE</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM>SQL SELECT * FROM TABLE2;</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM>LOAD TEMP INTO TABLE.qvd;</EM></P><P></P><P>Please Guide me. Many Thanks for your help</P></BODY></HTML> Sat, 12 Aug 2017 14:41:47 GMT https://community.qlik.com/t5/QlikView/If-else-clause-in-the-script-of-Qlikview-lt-Script-line-error-gt/m-p/1392728#M820054 shmkmr90 2017-08-12T14:41:47Z Re: If else clause in the script of Qlikview <Script line error> https://community.qlik.com/t5/QlikView/If-else-clause-in-the-script-of-Qlikview-lt-Script-line-error-gt/m-p/1392729#M820055 <HTML><HEAD></HEAD><BODY><P>Missing a <STRONG>'Then'  </STRONG>may be?</P></BODY></HTML> Mon, 14 Aug 2017 07:34:56 GMT https://community.qlik.com/t5/QlikView/If-else-clause-in-the-script-of-Qlikview-lt-Script-line-error-gt/m-p/1392729#M820055 tresB 2017-08-14T07:34:56Z Re: If else clause in the script of Qlikview <Script line error> https://community.qlik.com/t5/QlikView/If-else-clause-in-the-script-of-Qlikview-lt-Script-line-error-gt/m-p/1392730#M820056 <HTML><HEAD></HEAD><BODY><P>It should be like below. Remove Parenthesis in your IF statement. Because, IF statement need two arguments</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>IF weekday(today())='Sat' THEN</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>SQL SELECT * FROM TABLE1;</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>ELSE</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>SQL SELECT * FROM TABLE2;</STRONG></P></BODY></HTML> Mon, 14 Aug 2017 07:44:39 GMT https://community.qlik.com/t5/QlikView/If-else-clause-in-the-script-of-Qlikview-lt-Script-line-error-gt/m-p/1392730#M820056 Anil_Babu_Samineni 2017-08-14T07:44:39Z Re: If else clause in the script of Qlikview <Script line error> https://community.qlik.com/t5/QlikView/If-else-clause-in-the-script-of-Qlikview-lt-Script-line-error-gt/m-p/1392731#M820057 <HTML><HEAD></HEAD><BODY><P>Try like this</P><P></P><P><IMG alt="if.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/173309_if.png" style="height: 197px; width: 620px;" /></P></BODY></HTML> Mon, 14 Aug 2017 07:52:04 GMT https://community.qlik.com/t5/QlikView/If-else-clause-in-the-script-of-Qlikview-lt-Script-line-error-gt/m-p/1392731#M820057 prma7799 2017-08-14T07:52:04Z Re: If else clause in the script of Qlikview <Script line error> https://community.qlik.com/t5/QlikView/If-else-clause-in-the-script-of-Qlikview-lt-Script-line-error-gt/m-p/1392732#M820058 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/qlik-users/218859">loveisfail</A>‌ one small correction you should close the if condition</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">IF weekday(today())='Sat' THEN</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">SQL SELECT * FROM TABLE1;</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">ELSE</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">SQL SELECT * FROM TABLE2;</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">END IF</STRONG></P></BODY></HTML> Mon, 14 Aug 2017 07:53:14 GMT https://community.qlik.com/t5/QlikView/If-else-clause-in-the-script-of-Qlikview-lt-Script-line-error-gt/m-p/1392732#M820058 avinashelite 2017-08-14T07:53:14Z Re: If else clause in the script of Qlikview <Script line error> https://community.qlik.com/t5/QlikView/If-else-clause-in-the-script-of-Qlikview-lt-Script-line-error-gt/m-p/1392733#M820059 <HTML><HEAD></HEAD><BODY><P>Noted !! But, I don't think whether we need close IF statement like you mentioned. Tested and done. This Statement required when we having the script after that Else statement. </P><P></P><P>Thanks for correct root </P></BODY></HTML> Mon, 14 Aug 2017 07:55:45 GMT https://community.qlik.com/t5/QlikView/If-else-clause-in-the-script-of-Qlikview-lt-Script-line-error-gt/m-p/1392733#M820059 Anil_Babu_Samineni 2017-08-14T07:55:45Z