topic Syntax error in QlikView https://community.qlik.com/t5/QlikView/Syntax-error/m-p/1274816#M871020 <HTML><HEAD></HEAD><BODY><P>=sum(</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if(&nbsp;&nbsp;&nbsp; </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; aggr(sum({&lt;[Control Description]={"Policy New Business", "Policy Cancellations"},</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [Fiscal Year Month] = date(addmonths(today(), -1), 'YYYY-MM') &gt;}</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [Record Count]),</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Country)=0,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,0)) &gt; 0</P><P></P><P>Can anyone see what is wrong with this code above? I want to say [Fiscal Year Month] = last month (2016-10)</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT bobbydave 2020-11-25T16:16:04Z Syntax error https://community.qlik.com/t5/QlikView/Syntax-error/m-p/1274816#M871020 <HTML><HEAD></HEAD><BODY><P>=sum(</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if(&nbsp;&nbsp;&nbsp; </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; aggr(sum({&lt;[Control Description]={"Policy New Business", "Policy Cancellations"},</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [Fiscal Year Month] = date(addmonths(today(), -1), 'YYYY-MM') &gt;}</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [Record Count]),</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Country)=0,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,0)) &gt; 0</P><P></P><P>Can anyone see what is wrong with this code above? I want to say [Fiscal Year Month] = last month (2016-10)</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Syntax-error/m-p/1274816#M871020 bobbydave 2020-11-25T16:16:04Z Re: Syntax error https://community.qlik.com/t5/QlikView/Syntax-error/m-p/1274817#M871021 <HTML><HEAD></HEAD><BODY><P>May be try this</P><P></P><P>=sum(</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if(&nbsp;&nbsp; </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; aggr(sum({&lt;[Control Description]={'Policy New Business', 'Policy Cancellations'},</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [Fiscal Year Month] = <STRONG>{"=date(addmonths(today(), -1), 'YYYY-MM')"}</STRONG> &gt;}[Record Count]),Country)=0,1,0)) &gt; 0</P></BODY></HTML> Fri, 18 Nov 2016 14:18:38 GMT https://community.qlik.com/t5/QlikView/Syntax-error/m-p/1274817#M871021 settu_periasamy 2016-11-18T14:18:38Z Re: Syntax error https://community.qlik.com/t5/QlikView/Syntax-error/m-p/1274818#M871022 <HTML><HEAD></HEAD><BODY><P>You may forget $</P><P></P><P style="font-size: 28.6924px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">=sum(</P><P style="font-size: 28.6924px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if(&nbsp; </P><P style="font-size: 28.6924px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; aggr(sum({&lt;[Control Description]={'Policy New Business', 'Policy Cancellations'},</P><P style="font-size: 28.6924px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [Fiscal Year Month] = <STRONG style="font-style: inherit; font-size: 28.6924px; font-family: inherit;">{"$(=date(addmonths(today(), -1), 'YYYY-MM'))"}</STRONG>&gt;}[Record Count]),Country)=0,1,0)) &gt; 0</P></BODY></HTML> Sat, 19 Nov 2016 02:30:56 GMT https://community.qlik.com/t5/QlikView/Syntax-error/m-p/1274818#M871022 Anil_Babu_Samineni 2016-11-19T02:30:56Z