topic Re: Not good at load scripts! in QlikView https://community.qlik.com/t5/QlikView/Not-good-at-load-scripts/m-p/532273#M1140093 <HTML><HEAD></HEAD><BODY><P>if(match(REFERRAL_STATUS_ID,100,200),1,0) as Flag</P><P></P><P>If you want the opposite switch around the 1 and 0.</P></BODY></HTML> Tue, 17 Sep 2013 16:09:49 GMT Gysbert_Wassenaar 2013-09-17T16:09:49Z Not good at load scripts! https://community.qlik.com/t5/QlikView/Not-good-at-load-scripts/m-p/532272#M1140092 <HTML><HEAD></HEAD><BODY><P>I am sure this will be an easy question for most of you but I can not figure out the syntax of the if statement in my load script....</P><P></P><P>If the referral status ID equals 100 <SPAN style="text-decoration: underline;">OR</SPAN> 200 then I want to flag it with a 1!</P><P></P><P>IF(REFERRAL_STATUS_ID &lt;&gt; ('100','200') ,1,0)</P><P></P><P>...I am not good at coding! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/blush.png" /></P></BODY></HTML> Tue, 17 Sep 2013 16:07:46 GMT https://community.qlik.com/t5/QlikView/Not-good-at-load-scripts/m-p/532272#M1140092 2013-09-17T16:07:46Z Re: Not good at load scripts! https://community.qlik.com/t5/QlikView/Not-good-at-load-scripts/m-p/532273#M1140093 <HTML><HEAD></HEAD><BODY><P>if(match(REFERRAL_STATUS_ID,100,200),1,0) as Flag</P><P></P><P>If you want the opposite switch around the 1 and 0.</P></BODY></HTML> Tue, 17 Sep 2013 16:09:49 GMT https://community.qlik.com/t5/QlikView/Not-good-at-load-scripts/m-p/532273#M1140093 Gysbert_Wassenaar 2013-09-17T16:09:49Z Re: Not good at load scripts! https://community.qlik.com/t5/QlikView/Not-good-at-load-scripts/m-p/532274#M1140095 <HTML><HEAD></HEAD><BODY><P>Thank you, I have not used Match before!</P></BODY></HTML> Tue, 17 Sep 2013 16:19:31 GMT https://community.qlik.com/t5/QlikView/Not-good-at-load-scripts/m-p/532274#M1140095 2013-09-17T16:19:31Z Re: Not good at load scripts! https://community.qlik.com/t5/QlikView/Not-good-at-load-scripts/m-p/532275#M1140097 <HTML><HEAD></HEAD><BODY><P>hi, try this</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">IF( REFERRAL_STATUS_ID = 100 OR <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">REFERRAL_STATUS_ID = 200</SPAN> ,1,0) AS Flag.</SPAN></P><P></P><P>Hope it help...</P><P></P><P></P><P>Khan</P></BODY></HTML> Tue, 17 Sep 2013 16:22:57 GMT https://community.qlik.com/t5/QlikView/Not-good-at-load-scripts/m-p/532275#M1140097 israrkhan 2013-09-17T16:22:57Z