topic Re: month subtraction and addition in QlikView https://community.qlik.com/t5/QlikView/month-subtraction-and-addition/m-p/396451#M147823 <HTML><HEAD></HEAD><BODY><P>Maybe like attached?</P><P></P><P>You can also use a pure numeric month field created in your script ( <EM>num(month(DATEFIELD)) as numMonth</EM> ), and filter your data using this field (don't forget to clear any calendar field that may conflict).</P><P></P><P>But even when using such a field, there is one potential problem at year bounderies. So it might be even better to use a date field instead of the month (maybe created by monthname() or monthstart()) and addmonths() function to step one month forward or back.</P><P></P><P>Hope this helps,</P><P>Stefan</P></BODY></HTML> Sat, 01 Dec 2012 23:50:54 GMT swuehl 2012-12-01T23:50:54Z month subtraction and addition https://community.qlik.com/t5/QlikView/month-subtraction-and-addition/m-p/396450#M147822 <HTML><HEAD></HEAD><BODY><P>I'm having issue with adding and subtracting month in set analysis. can you look at it and let me the issue.</P><P></P><P>Thanks,</P></BODY></HTML> Sat, 01 Dec 2012 19:56:54 GMT https://community.qlik.com/t5/QlikView/month-subtraction-and-addition/m-p/396450#M147822 2012-12-01T19:56:54Z Re: month subtraction and addition https://community.qlik.com/t5/QlikView/month-subtraction-and-addition/m-p/396451#M147823 <HTML><HEAD></HEAD><BODY><P>Maybe like attached?</P><P></P><P>You can also use a pure numeric month field created in your script ( <EM>num(month(DATEFIELD)) as numMonth</EM> ), and filter your data using this field (don't forget to clear any calendar field that may conflict).</P><P></P><P>But even when using such a field, there is one potential problem at year bounderies. So it might be even better to use a date field instead of the month (maybe created by monthname() or monthstart()) and addmonths() function to step one month forward or back.</P><P></P><P>Hope this helps,</P><P>Stefan</P></BODY></HTML> Sat, 01 Dec 2012 23:50:54 GMT https://community.qlik.com/t5/QlikView/month-subtraction-and-addition/m-p/396451#M147823 swuehl 2012-12-01T23:50:54Z