topic Re: MonthName(AddMonths...) in QlikView

MonthName(AddMonths...)

Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I have a problem with addmonth.

i write =monthname(AddMonths(AnnéeMois,-1)) but it's not working.

any help please

Re: MonthName(AddMonths...)

sunny_talwar — Mon, 25 Jul 2016 13:55:42 GMT

When you say its not working, can you elaborate what the issue is? Does it give you an error, or does it become null? What exactly is the issue?

On another note, have you made sure AnnéeMois is a date field and not text field formatted as date?

Re: MonthName(AddMonths...)

MindaugasBacius — Mon, 25 Jul 2016 13:59:01 GMT

If this works than the issues with the date formatting:

=MonthName(AddMonths(today(),-1))

Could you please let us know how your date field looks like and what kind of values do contain?

Re: MonthName(AddMonths...)

Tue, 26 Jul 2016 08:23:30 GMT

Hi Sunny,

it become null

Re: MonthName(AddMonths...)

sunny_talwar — Tue, 26 Jul 2016 08:46:27 GMT

My guess is that AnnéeMois is not read as a date. Can you try this:

=MonthName(AddMonths(Date#(AnnéeMois, 'DateFieldFormatHere'), -1))

Where you will replace DateFieldFormatHere with the format that is associated with AnnéeMois

Re: MonthName(AddMonths...)

Tue, 26 Jul 2016 09:12:14 GMT

it's not working

Re: MonthName(AddMonths...)

MindaugasBacius — Tue, 26 Jul 2016 12:13:09 GMT

Share with us how your AnnéeMois field looks like.

Re: MonthName(AddMonths...)

Tue, 26 Jul 2016 13:50:50 GMT

I think the problem is qlikview not read AnnéeMois like a date but i dont know how and what i can to do for to change this

Re: MonthName(AddMonths...)

Tue, 26 Jul 2016 13:51:14 GMT

AnnéeMois is like Juillet 2015

Re: MonthName(AddMonths...)

bertinabel — Tue, 26 Jul 2016 18:33:13 GMT

Hola Sami,

¿Ya probaste con la solución que te indicó Sunny T?

=MonthName(AddMonths(Date#('Jul 2015','MMM YYYY'),-1))

en u caso es reemplazar 'Jul 2015' por AnnéeMois

=MonthName(AddMonths(Date#(AnnéeMois,'MMMM YYYY'),-1))

Re: MonthName(AddMonths...)

Thu, 28 Jul 2016 09:29:20 GMT

Hello, I have another problem when I write

sum({<AnnéeMois = {'$(=monthname(AddMonths([Date Calendrier],-2)))'}>} Vol_Appels) in expression, it shows me 0 in result.

Can you help me please? thx

Re: MonthName(AddMonths...)

MindaugasBacius — Thu, 28 Jul 2016 11:02:11 GMT

It means that for that period there is no data in Vol_Appels field.

Re: MonthName(AddMonths...)

qlikview979 — Thu, 28 Jul 2016 11:18:29 GMT

Try this

=monthname(Date(AddMonths(AnnéeMois),-1))

may be this

monthname(=Date(AddMonths(AnnéeMois),-1))

Re: MonthName(AddMonths...)

lidiavonkrond — Wed, 11 Apr 2018 10:25:13 GMT

Hi All,

i have an unexpected result

SUM({$<[INVOICE MONTHNAME]={'$(=MONTHNAME(MAX(ADDMONTHS([INVOICE DATE],-1))))'}>}[COMM INVOICE AMOUNT])

test results

MAX(ADDMONTHS([INVOICE DATE],-1)) =>28/02/2018

ADDMONTHS(MAX([INVOICE DATE])) => 31/01/2018

MONTHNAME(MAX(ADDMONTHS([INVOICE DATE],-1))) apr 2018 this must be jan 2018

NUM(MONTHNAME(MAX(ADDMONTHS([INVOICE DATE],-1))) ) => 43101 this number stay for >31/01/2018

The same formula works totaly fine in an other application, so i expect there is something in the settings, but i can't find it. Please Help

With kind regards Lidia

main settings

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='€#,##0.00;(€#,##0.00)';

SET TimeFormat='hh.mm.ss';

SET DateFormat='DD/MM/YYYY';

SET TimestampFormat='DD/MM/YYYY HH:MM:SS[.fff] TT';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';

SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday';

Re: MonthName(AddMonths...)

shiveshsingh — Wed, 11 Apr 2018 10:40:09 GMT

What's the logic for this? MAX(ADDMONTHS([INVOICE DATE],-1))

Can you take max and then try addmonths? Can you share app?

Re: MonthName(AddMonths...)

lidiavonkrond — Tue, 01 May 2018 11:32:42 GMT

Hi shivesh,

thanks for respond

reverse max was not the option.

the solution is found in change of the calendar ordering in the datamodel and a change in the main settings with help of QlikSupport.

Lidia