topic Re: case to if in QlikView https://community.qlik.com/t5/QlikView/case-to-if/m-p/1366662#M835438 <HTML><HEAD></HEAD><BODY><P>Thank you Vishwarath</P></BODY></HTML> Wed, 31 May 2017 14:05:37 GMT 2017-05-31T14:05:37Z case to if https://community.qlik.com/t5/QlikView/case-to-if/m-p/1366658#M835434 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I'm trying to replicate the below statement in qlikview load script.</P><P>CASE WHEN (`Field1`-`Field2`) = 0 AND `Field3` = 0 THEN 'No' ELSE 'Yes' END</P><P></P><P></P><P>Thanks</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/case-to-if/m-p/1366658#M835434 2020-11-25T16:16:04Z Re: case to if https://community.qlik.com/t5/QlikView/case-to-if/m-p/1366659#M835435 <HTML><HEAD></HEAD><BODY><P>May be this?</P><P></P><P>IF(Field1-Field2 = 0 AND Field3 = 0, 'No', 'Yes') AS YourNewFieldName</P></BODY></HTML> Wed, 31 May 2017 13:34:28 GMT https://community.qlik.com/t5/QlikView/case-to-if/m-p/1366659#M835435 vishsaggi 2017-05-31T13:34:28Z Re: case to if https://community.qlik.com/t5/QlikView/case-to-if/m-p/1366660#M835436 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>May be (for script code)</P><P></P><P>IF Field1-Field2 = 0 And Field3 = 0</P><P>'No'</P><P>ELSE</P><P>'Yes'</P><P>END IF</P></BODY></HTML> Wed, 31 May 2017 13:35:07 GMT https://community.qlik.com/t5/QlikView/case-to-if/m-p/1366660#M835436 ahaahaaha 2017-05-31T13:35:07Z Re: case to if https://community.qlik.com/t5/QlikView/case-to-if/m-p/1366661#M835437 <HTML><HEAD></HEAD><BODY><P>Didnt you forget to add word "SQL" before Select?</P></BODY></HTML> Wed, 31 May 2017 14:02:53 GMT https://community.qlik.com/t5/QlikView/case-to-if/m-p/1366661#M835437 zhuravlevleonid 2017-05-31T14:02:53Z Re: case to if https://community.qlik.com/t5/QlikView/case-to-if/m-p/1366662#M835438 <HTML><HEAD></HEAD><BODY><P>Thank you Vishwarath</P></BODY></HTML> Wed, 31 May 2017 14:05:37 GMT https://community.qlik.com/t5/QlikView/case-to-if/m-p/1366662#M835438 2017-05-31T14:05:37Z Re: case to if https://community.qlik.com/t5/QlikView/case-to-if/m-p/1366663#M835439 <HTML><HEAD></HEAD><BODY><P>Hello, Naveen!</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">It's the same is (if you want it within script):</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">IF(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Field1-Field2=0 AND Field3=0,'No','Yes') as FLG</SPAN></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P></BODY></HTML> Wed, 31 May 2017 14:06:18 GMT https://community.qlik.com/t5/QlikView/case-to-if/m-p/1366663#M835439 Sergey_Shuklin 2017-05-31T14:06:18Z