topic financial qtr script error in QlikView https://community.qlik.com/t5/QlikView/financial-qtr-script-error/m-p/494773#M185046 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>i have the follwoing script in my calender</P><P></P><P>Upper(Month(monthstart($(TimeField)-26,1))) as Month,</P><P></P><P>how can i get my quarters code to follow this logic?</P><P></P><P>Dual('Q'&amp;Num(Ceil(Num(Month($(TimeField)))/3)),Num(Ceil(NUM(Month($(Timefield)))/3),00)) as [Quarter],</P><P></P><P></P><P>I HAVE TTRIED THE FOLLOWING</P><P>Dual('Q'&amp;Num(Ceil(Num(Month($(TimeField)-26,1))/3)),Num(Ceil(NUM(Month($(Timefield)-26,1))/3),00)) as [Quarter],</P><P></P><P>best</P><P></P><P>BRAD</P></BODY></HTML> Wed, 14 Aug 2013 18:01:08 GMT 2013-08-14T18:01:08Z financial qtr script error https://community.qlik.com/t5/QlikView/financial-qtr-script-error/m-p/494773#M185046 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>i have the follwoing script in my calender</P><P></P><P>Upper(Month(monthstart($(TimeField)-26,1))) as Month,</P><P></P><P>how can i get my quarters code to follow this logic?</P><P></P><P>Dual('Q'&amp;Num(Ceil(Num(Month($(TimeField)))/3)),Num(Ceil(NUM(Month($(Timefield)))/3),00)) as [Quarter],</P><P></P><P></P><P>I HAVE TTRIED THE FOLLOWING</P><P>Dual('Q'&amp;Num(Ceil(Num(Month($(TimeField)-26,1))/3)),Num(Ceil(NUM(Month($(Timefield)-26,1))/3),00)) as [Quarter],</P><P></P><P>best</P><P></P><P>BRAD</P></BODY></HTML> Wed, 14 Aug 2013 18:01:08 GMT https://community.qlik.com/t5/QlikView/financial-qtr-script-error/m-p/494773#M185046 2013-08-14T18:01:08Z