topic Re: Get Previous Month from Today's date in QlikView

Get Previous Month from Today's date

kushalthakral — Wed, 30 Apr 2014 08:51:59 GMT

Dear All

How i can get Previous month from Current date as i need to generate QVD and use Month and Year as their filed using system date.

Thanks

Kushal Thakral

Re: Get Previous Month from Today's date

MK_QSL — Wed, 30 Apr 2014 08:53:33 GMT

Month(Today())-1 as PreviousMonth

Update : The above will give you month number.

If you want month number, use below

in script

=Subfield('$(MonthNames)',';',Month(Today())-1) as PreviousMonth

in UI

=Subfield('$(MonthNames)',';',Month(Today())-1)

Re: Get Previous Month from Today's date

anbu1984 — Wed, 30 Apr 2014 08:57:48 GMT

Month(AddMonths(Today(),-1))

Re: Get Previous Month from Today's date

its_anandrjs — Wed, 30 Apr 2014 08:58:17 GMT

Write like

Month(Max(DateField))-1 as PreviousMonth

What is mean for QVD generate and used Month Year

Re: Get Previous Month from Today's date

anbu1984 — Wed, 30 Apr 2014 09:01:04 GMT

Manish,

If Month is January, Month(Today())-1 is zero and you will get nothing from this expression

Subfield('$(MonthNames)',';',Month(Date#('01/01/2014','D/M/YYYY'))-1)

Re: Get Previous Month from Today's date

MK_QSL — Wed, 30 Apr 2014 09:05:21 GMT

IF(Month(Date(YourDateField))-1=0,12,Month(Date(YourDateField))-1)

=Subfield('$(MonthNames)',';',IF(Month(Date(YourDateField))-1=0,12,Month(Date(YourDateField))-1))

Re: Get Previous Month from Today's date

kushalthakral — Wed, 30 Apr 2014 09:21:02 GMT

Dear All

I dont have Date field so need to calculate Month and Year using system date

So can you help with the same.

Thanks

Kushal

Re: Get Previous Month from Today's date

MK_QSL — Wed, 30 Apr 2014 09:23:42 GMT

IF(Month(Today())-1=0,12,Month(Today())-1)

=Subfield('$(MonthNames)',';',IF(Month(Today())-1=0,12,Month(Today())-1))

Re: Get Previous Month from Today's date

anbu1984 — Wed, 30 Apr 2014 09:26:33 GMT

Previous month

Month(AddMonths(Today(),-1))

Previous Year

Year(AddMonths(Today(),-1))

Current Month

Month(Today())

Current Year

Year(Today())

Re: Get Previous Month from Today's date

Wed, 30 Apr 2014 09:27:23 GMT

Hi Kushal,

You try the following Syntax-:

=SUM({<MONTH={">=$(=MIN(MONTH)-1)<=$(=MAX(MONTH)-1)"}>}FIELDNAME)

it definitely work.

Re: Get Previous Month from Today's date

SunilChauhan — Wed, 30 Apr 2014 09:36:03 GMT

see the attched file

hope this helps

Re: Get Previous Month from Today's date

preminqlik — Wed, 30 Apr 2014 09:38:27 GMT

NEWTABLE:

Load *,

Month(AddMonths(Today(),-1)) as PreviousMonth,

Year(AddMonths(Today(),-1)) as PreviousYear

resident Orginal;

store NEWTABLE into path\NEWTABLE.QVD;

Re: Get Previous Month from Today's date

kushalthakral — Wed, 30 Apr 2014 10:09:44 GMT

Thank You ALL

Regards

Kushal Thakral

Re: Get Previous Month from Today's date

richard_pearce6 — Tue, 27 May 2014 16:07:53 GMT

Here's a calendar which allows you to determine previous periods depending on dates using flags

http://community.qlik.com/docs/DOC-6593

Regards

Richard

QlikCentral.Com