Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a problem with addmonth.
i write =monthname(AddMonths(AnnéeMois,-1)) but it's not working.
any help please
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
It means that for that period there is no data in Vol_Appels field.
Try this
=monthname(Date(AddMonths(AnnéeMois),-1))
or
may be this
monthname(=Date(AddMonths(AnnéeMois),-1))
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';
What's the logic for this? MAX(ADDMONTHS([INVOICE DATE],-1))
Can you take max and then try addmonths? Can you share app?
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