topic Next Month in QlikView https://community.qlik.com/t5/QlikView/Next-Month/m-p/243260#M1207028 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have a table with a field Monthname Jan09, Feb09, Mar09, ...</P><P>I'd like to calculate for each Monthname an expression depending of the next month. If I try Montname + 1 it doesnt work but if I try</P><P>Monthname +31 it works. Is there another way to use the next month</P><P></P><P>Thanks for any help</P><P>Jean-Jacques</P><P></P><P></P><P></P></BODY></HTML> Wed, 17 Feb 2010 20:39:31 GMT 2010-02-17T20:39:31Z Next Month https://community.qlik.com/t5/QlikView/Next-Month/m-p/243260#M1207028 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have a table with a field Monthname Jan09, Feb09, Mar09, ...</P><P>I'd like to calculate for each Monthname an expression depending of the next month. If I try Montname + 1 it doesnt work but if I try</P><P>Monthname +31 it works. Is there another way to use the next month</P><P></P><P>Thanks for any help</P><P>Jean-Jacques</P><P></P><P></P><P></P></BODY></HTML> Wed, 17 Feb 2010 20:39:31 GMT https://community.qlik.com/t5/QlikView/Next-Month/m-p/243260#M1207028 2010-02-17T20:39:31Z Next Month https://community.qlik.com/t5/QlikView/Next-Month/m-p/243261#M1207029 <HTML><HEAD></HEAD><BODY><P>You should be able to use your date field with the monthstart function to get a specific date in that month.</P><P>From here you can then use the addmonths function for it to return next months data.</P><P>Hope this is of help,</P><P>Regards,</P><P>Neil</P></BODY></HTML> Wed, 17 Feb 2010 20:49:23 GMT https://community.qlik.com/t5/QlikView/Next-Month/m-p/243261#M1207029 2010-02-17T20:49:23Z