topic Re: Month processing issue in QlikView

Month processing issue

Mon, 26 Jan 2026 18:19:17 GMT

Good morning,

I am using the following expression as part of Set analysis to derive PT values for a month (it works)

Sum ({$<MonthExp={$(=Only(MonthExp))}>}PT)

When I try to deribe the prior month's values, I am using the following:

Sum ({$<MonthExp={$(=Only(MonthExp)-1)}>}PT) and instead of getting the previous month , i.e 'Mar' I am getting the value of 3 and not able to derive the prior month's values.

Please help.

Thank you

Re: Month processing issue

sunny_talwar — Wed, 11 May 2016 12:58:26 GMT

Value of 3? Can you may be share a screenshot or a sampl?

Re: Month processing issue

PrashantSangle — Wed, 11 May 2016 13:03:02 GMT

Hi,

create new variable to calculate previous month and use that in your set analysis.

Provide more details.

Kind Regards

Re: Month processing issue

Wed, 11 May 2016 13:04:54 GMT

Why does -1 not work?

Re: Month processing issue

trdandamudi — Wed, 11 May 2016 13:06:49 GMT

May be this: ( I don't know your date format, So change accordingly...)

Sum ({$<MonthExp={$(=Only(Month(MonthExp)-1))}>}PT)

Re: Month processing issue

PrashantSangle — Wed, 11 May 2016 13:10:50 GMT

Hi,

Qlikview store data in dual datatype.

Whenever you perform arithmetic operation on date it convert it into number .

therefore you are getting 3 instead of mar.

Kind Regards,

Re: Month processing issue

Wed, 11 May 2016 14:31:05 GMT

Unfortunately this this did not work

With MonthExp = 'Apr' , the result was '0' instead of 'Mar'

Re: Month processing issue

Wed, 11 May 2016 14:37:55 GMT

I changed it to be:

Sum ({$<MonthExp={$(=Only(Month((MonthExp)-1)))}>}PT)

and instead of 'Mar' it returned 'Jan'

It looks like it's going back to the beginning of the quarter?

Re: Month processing issue

trdandamudi — Wed, 11 May 2016 14:42:43 GMT

Can you please post a small sample app ....

Re: Month processing issue

sunny_talwar — Wed, 11 May 2016 14:44:32 GMT

Can you create a new field in the script and call it MonthNum

Num(Month(TempDate)) as MonthNum

and use this in your equation

Sum({$<MonthNum={$(=Only(MonthNum)-1)}>}PT)

Or completely get rid of Months because they are confusing and use dates instead:

Sum({<Date = {"$(='>=' & Date(MonthStart(Max(Date), -1), 'DateFieldFormatHere') & '<=' & Date(MonthEnd(Max(Date), -1), 'DateFieldFormatHere'))"}>} PT)

Re: Month processing issue

Wed, 11 May 2016 15:55:58 GMT

Using MonthNum really helped - Thank you very much

I have MonthNum in my column headings - is there any easy way to convert to the Month Name for presentation purposes?

Re: Month processing issue

sunny_talwar — Wed, 11 May 2016 15:59:57 GMT

I guess continue to use MonthExp for the expression label so that you continue to see the month.

Also make sure you understand that when you use MonthNum... Things become difficult when its Jan. So make sure you really want to use month instead of date.

Now if you got what you wanted, I would request you to close the thread by marking correct and helpful answers.

Best,

Sunny