topic MonthYear -1 in QlikView https://community.qlik.com/t5/QlikView/MonthYear-1/m-p/751363#M1036165 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a requirement where I have to take MonthName of a particular value -1</P><P>Eg : if Its Sep - 2014 it has to be Aug - 2014</P><P></P><P>I have used the following expression But its not working,</P><P>Please help.</P><P></P><P></P><P>=AddMonths(GetFieldSelections(FieldName),-1)</P></BODY></HTML> Thu, 08 Jan 2015 04:24:36 GMT Muthu 2015-01-08T04:24:36Z MonthYear -1 https://community.qlik.com/t5/QlikView/MonthYear-1/m-p/751363#M1036165 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a requirement where I have to take MonthName of a particular value -1</P><P>Eg : if Its Sep - 2014 it has to be Aug - 2014</P><P></P><P>I have used the following expression But its not working,</P><P>Please help.</P><P></P><P></P><P>=AddMonths(GetFieldSelections(FieldName),-1)</P></BODY></HTML> Thu, 08 Jan 2015 04:24:36 GMT https://community.qlik.com/t5/QlikView/MonthYear-1/m-p/751363#M1036165 Muthu 2015-01-08T04:24:36Z Re: MonthYear -1 https://community.qlik.com/t5/QlikView/MonthYear-1/m-p/751364#M1036166 <HTML><HEAD></HEAD><BODY><P>Over a field Fecha.</P><P></P><P>=MonthName(AddMonths(MonthName(Max(Fecha)),-1))</P><P></P><P><IMG __jive_id="74799" alt="p10.png" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/74799_p10.png" style="height: 452px; width: 620px;" /></P></BODY></HTML> Thu, 08 Jan 2015 04:46:58 GMT https://community.qlik.com/t5/QlikView/MonthYear-1/m-p/751364#M1036166 ecolomer 2015-01-08T04:46:58Z Re: MonthYear -1 https://community.qlik.com/t5/QlikView/MonthYear-1/m-p/751365#M1036167 <HTML><HEAD></HEAD><BODY><P>Try like:</P><P>MonthName( SelectedDatefield, -1)</P></BODY></HTML> Thu, 08 Jan 2015 04:48:16 GMT https://community.qlik.com/t5/QlikView/MonthYear-1/m-p/751365#M1036167 tresB 2015-01-08T04:48:16Z Re: MonthYear -1 https://community.qlik.com/t5/QlikView/MonthYear-1/m-p/751366#M1036168 <HTML><HEAD></HEAD><BODY><P>Probably you need convert to date </P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">=MonthName(AddMonths(MonthName(GetFieldSelections(FieldName)),-1))</SPAN></P></BODY></HTML> Thu, 08 Jan 2015 04:48:19 GMT https://community.qlik.com/t5/QlikView/MonthYear-1/m-p/751366#M1036168 ecolomer 2015-01-08T04:48:19Z Re: MonthYear -1 https://community.qlik.com/t5/QlikView/MonthYear-1/m-p/751367#M1036169 <HTML><HEAD></HEAD><BODY><P>=MonthName([MonthName(Date)]-1)</P></BODY></HTML> Thu, 08 Jan 2015 05:04:33 GMT https://community.qlik.com/t5/QlikView/MonthYear-1/m-p/751367#M1036169 tyagishaila 2015-01-08T05:04:33Z Re: MonthYear -1 https://community.qlik.com/t5/QlikView/MonthYear-1/m-p/751368#M1036170 <HTML><HEAD></HEAD><BODY><P>thanks a lot.. it worked</P></BODY></HTML> Mon, 12 Jan 2015 01:45:51 GMT https://community.qlik.com/t5/QlikView/MonthYear-1/m-p/751368#M1036170 Muthu 2015-01-12T01:45:51Z