topic Re: Create new variable in load script with OR in QlikView https://community.qlik.com/t5/QlikView/Re-Create-new-variable-in-load-script-with-OR/m-p/313341#M115673 <HTML><HEAD></HEAD><BODY><P>Thank you Sunil!</P><P>But I do not understand your syntax. </P><P>Did you mean like this?</P><P></P><P>Load </P><P>Time,</P><P>Client_ID<STRONG style="color: #ff0000;">,</STRONG></P><P><SPAN style="color: #008000;">if(sum(Happy_client)&gt;0,1)</SPAN> <SPAN style="color: #ff0000;">as Good_time,</SPAN><SPAN style="color: #ffffff;"><STRONG>Good time</STRONG></SPAN><SPAN style="color: #ff0000;"> </SPAN><SPAN style="color: #ffffff;"><STRONG>Good time</STRONG></SPAN><SPAN style="color: #ffffff;"><STRONG>Good time</STRONG></SPAN><SPAN style="color: #ff0000;"> </SPAN></P><P>from path </P><P>group by&nbsp; Time ,Client_ID;</P><P></P><P>Sounds good, but I would like to use no "if", because this makes everything very slow. So I use an "<STRONG>OR</STRONG>".</P><P>1-product(1-Happy_client) </P><P>But how is the function for Products called?</P></BODY></HTML> Thu, 23 Feb 2012 13:19:34 GMT 2012-02-23T13:19:34Z Re: Create new variable in load script with OR https://community.qlik.com/t5/QlikView/Re-Create-new-variable-in-load-script-with-OR/m-p/313341#M115673 <HTML><HEAD></HEAD><BODY><P>Thank you Sunil!</P><P>But I do not understand your syntax. </P><P>Did you mean like this?</P><P></P><P>Load </P><P>Time,</P><P>Client_ID<STRONG style="color: #ff0000;">,</STRONG></P><P><SPAN style="color: #008000;">if(sum(Happy_client)&gt;0,1)</SPAN> <SPAN style="color: #ff0000;">as Good_time,</SPAN><SPAN style="color: #ffffff;"><STRONG>Good time</STRONG></SPAN><SPAN style="color: #ff0000;"> </SPAN><SPAN style="color: #ffffff;"><STRONG>Good time</STRONG></SPAN><SPAN style="color: #ffffff;"><STRONG>Good time</STRONG></SPAN><SPAN style="color: #ff0000;"> </SPAN></P><P>from path </P><P>group by&nbsp; Time ,Client_ID;</P><P></P><P>Sounds good, but I would like to use no "if", because this makes everything very slow. So I use an "<STRONG>OR</STRONG>".</P><P>1-product(1-Happy_client) </P><P>But how is the function for Products called?</P></BODY></HTML> Thu, 23 Feb 2012 13:19:34 GMT https://community.qlik.com/t5/QlikView/Re-Create-new-variable-in-load-script-with-OR/m-p/313341#M115673 2012-02-23T13:19:34Z