topic Re: Help with expression in QlikView https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/940754#M960330 <HTML><HEAD></HEAD><BODY><P>Try</P><P>Addmonths (date,-1)</P></BODY></HTML> Wed, 21 Oct 2015 16:11:18 GMT settu_periasamy 2015-10-21T16:11:18Z Help with expression https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/940753#M960329 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P></P><P>I have a date field which I would like to create an expression to look at this field and give me the previous month.</P><P></P><P>For example</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Month(date_field) -1 </P><P></P><P>But that doesn't work! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/silly.png" /></P><P></P><P>So basically if the data is 21/10/2015 I want to get the previous month 21/09/2015</P><P></P><P>I am interested in the month though and not the actual date.</P><P></P><P>Hope this all makes sense?! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Thanks !</P></BODY></HTML> Wed, 21 Oct 2015 16:09:16 GMT https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/940753#M960329 Anonymous 2015-10-21T16:09:16Z Re: Help with expression https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/940754#M960330 <HTML><HEAD></HEAD><BODY><P>Try</P><P>Addmonths (date,-1)</P></BODY></HTML> Wed, 21 Oct 2015 16:11:18 GMT https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/940754#M960330 settu_periasamy 2015-10-21T16:11:18Z Re: Help with expression https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/940755#M960331 <HTML><HEAD></HEAD><BODY><P>month(addmonths(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">date_field</SPAN>, -1))</P></BODY></HTML> Wed, 21 Oct 2015 16:15:08 GMT https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/940755#M960331 maxgro 2015-10-21T16:15:08Z Re: Help with expression https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/940756#M960332 <HTML><HEAD></HEAD><BODY><P>See below. I hope to help you.</P><P><A href="https://community.qlik.com/docs/DOC-6593">Calendar with flags making set analysis so very simple</A></P></BODY></HTML> Wed, 21 Oct 2015 16:22:03 GMT https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/940756#M960332 ElizaF 2015-10-21T16:22:03Z Re: Help with expression https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/940757#M960333 <HTML><HEAD></HEAD><BODY><P>Thanks for your help as always guys! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/laugh.png" /></P></BODY></HTML> Thu, 22 Oct 2015 10:23:43 GMT https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/940757#M960333 Anonymous 2015-10-22T10:23:43Z