topic Re: Last Three Months in QlikView

Last Three Months

Tue, 19 Nov 2013 07:32:03 GMT

Hi,

I'm trying to get the Month names for last three months.

I can get the current month name using the following expression:

Month(Today())

it returns me Nov.

But when I try using Month(Today())-1 it returns the value 10 instead of Oct.

To solve this issue I tried using Monthname(month(Today())-1) but it returns the value 'Jan 1900' instead of converting the '10' in Oct.

How can I get the previous month name?

kaushiknsolanki — Tue, 19 Nov 2013 07:41:54 GMT

Hi,

Try Addmonths Function.

=Month(Addmonths(Today(),-1))

To get Previous Month.

=Month(Addmonths(Today(),-2)) - to get the Month of Previous to Previous Month.

Regards,

Kaushik Solanki

Tue, 19 Nov 2013 07:46:16 GMT

Month(AddMonths(today(),-1))

U can use it to return previous month...

Tue, 19 Nov 2013 07:54:57 GMT

Thanks. It worked

Tue, 19 Nov 2013 07:55:49 GMT

The Kaushik Solanki response is correct to get the previous months. Then you can use the Date function to format that dates as desired:

=Date(AddMonths(Today(), -1), 'M') --> 10

=Date(AddMonths(Today(), -1), 'MMM') --> oct

=Date(AddMonths(Today(), -1), 'MMMM') --> october