topic Re: error in script in QlikView https://community.qlik.com/t5/QlikView/error-in-script/m-p/780806#M276643 <HTML><HEAD></HEAD><BODY><P>The expression editor doesn't understand -= and will show the expression as incorrect. But that's a bug in the expression editor. It does not necessarily mean that the expression is incorrect and will not work.</P></BODY></HTML> Wed, 28 Jan 2015 13:45:07 GMT Gysbert_Wassenaar 2015-01-28T13:45:07Z error in script https://community.qlik.com/t5/QlikView/error-in-script/m-p/780805#M276642 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #0000ff; font-size: 8pt;">Hi All,</SPAN></P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">I got an error below highlighted pink colored code... </SPAN></P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">if</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">len</SPAN><SPAN style="font-size: 8pt;">(</SPAN><STRONG><EM style=": ; color: #808080; font-size: 8pt;">RegFromDate</EM></STRONG><SPAN style="font-size: 8pt;">)&gt;0 </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">and</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">len</SPAN><SPAN style="font-size: 8pt;">(</SPAN><STRONG><EM style=": ; color: #808080; font-size: 8pt;">RegToDate</EM></STRONG><SPAN style="font-size: 8pt;">)&gt;0,<BR /> <BR /> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">aggr</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">REGISTERED_DT_Num</SPAN><SPAN style="font-size: 8pt;">={</SPAN><SPAN style="color: #800000; font-size: 8pt;">"&gt;=$(RegFromDate) &lt;= $(RegToDate)"</SPAN><SPAN style="font-size: 8pt;">},</SPAN><SPAN style="color: #800000; font-size: 8pt;">STATUS</SPAN><SPAN style="font-size: 8pt;"> = {'Settled'}, </SPAN><SPAN style="color: #800000; font-size: 8pt;">TYPE_CLM</SPAN><SPAN style="font-size: 8pt;">={'Star Care Plus 4'}, </SPAN><SPAN style="color: #800000; font-size: 8pt;">STAR_CARE_SHARE_PART</SPAN><SPAN style="font-size: 8pt;">=-{0},</SPAN><SPAN style="color: #800000; font-size: 8pt;">X_PRODUCT_LINE</SPAN><SPAN style="font-size: 8pt;">=<SPAN style="color: #ff00ff; font-size: 12pt;">&gt;}</SPAN><BR /> WOClaimed),Dealer_Alias,NAME_DIV,WRNTY_NUM)),<BR /> <BR /> sum(aggr(sum({&lt;STATUS = {'Settled'}, TYPE_CLM={'Star Care Plus 4'}, STAR_CARE_SHARE_PART=-{0},X_PRODUCT_LINE=&gt;}WOClaimed),Dealer_Alias,NAME_DIV,WRNTY_NUM))<BR /> <BR /> ) </SPAN></P><P></P><P></P><P>Thanks</P></BODY></HTML> Wed, 28 Jan 2015 11:11:23 GMT https://community.qlik.com/t5/QlikView/error-in-script/m-p/780805#M276642 prma7799 2015-01-28T11:11:23Z Re: error in script https://community.qlik.com/t5/QlikView/error-in-script/m-p/780806#M276643 <HTML><HEAD></HEAD><BODY><P>The expression editor doesn't understand -= and will show the expression as incorrect. But that's a bug in the expression editor. It does not necessarily mean that the expression is incorrect and will not work.</P></BODY></HTML> Wed, 28 Jan 2015 13:45:07 GMT https://community.qlik.com/t5/QlikView/error-in-script/m-p/780806#M276643 Gysbert_Wassenaar 2015-01-28T13:45:07Z