Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

MonthName(AddMonths...)

Hello,

I have a problem with addmonth.

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

any help please

15 Replies
Not applicable
Author

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

MindaugasBacius
Partner - Specialist III
Partner - Specialist III

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

qlikview979
Specialist
Specialist

Try this

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



or


may be this



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

lidiavonkrond
Partner - Contributor III
Partner - Contributor III

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';



shiveshsingh
Master
Master

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


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

lidiavonkrond
Partner - Contributor III
Partner - Contributor III

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