topic Re: Getting Previous Year as text in QlikView

Getting Previous Year as text

Wed, 08 Oct 2014 05:25:06 GMT

Hi,

I am selecting a month (ex- Sep 13) from list box. I have text box where in I want to display Oct 12 as output.

Any idea how to do that.

I tried with the following

date(num(Month-365),'MMM-YY')

But, it doesnt work. It throws Sep 12. Here Month is a field in table having values like May 13, June 13 etc..

PrashantSangle — Wed, 08 Oct 2014 05:28:49 GMT

Hi,

Try this

AddMonths(Date#(YourField,'MMM YY'),-11)

use AddYears(Date#(YourField,'MMM YY'),-1)

Regards

PrashantSangle — Wed, 08 Oct 2014 05:30:28 GMT

Hi,

If you want output in MMM YY format

Then write

Date(AddMonths(Date#(YourField,'MMM YY'),-11),'MMM YY')

Regards

Wed, 08 Oct 2014 05:33:30 GMT

Thanks mate..it works..

jyothish8807 — Wed, 08 Oct 2014 05:35:37 GMT

Hi Vimal;

Try:

=Date(Addmonths(date#([Your field]),-11),'MMM YY')

Regards