Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help for expression date-2

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

7 Replies
tyagishaila
Specialist
Specialist

to know what is issue, you have to share Sample data.

Because Output is not null '-' , it is '0', it means expression is correct,.

MindaugasBacius
Partner - Specialist III
Partner - Specialist III

How does your Date field look like?

Not applicable
Author

volcallMoisannée
A5012001
b3022001
c132001
d2542001
e552001
f562001
i672001
g882001
saimahasan
Partner - Creator III
Partner - Creator III

Please share sample application

Anil_Babu_Samineni

sum({<AnnéeMois = {"$(=monthname(AddMonths([Date Calendrier],-2)))"}>} Vol_Appels)


Use Double Quotes

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Not applicable
Author

volappMoisannée
A5012001
b3022001
c132001
d2542001
e552001
f562001
i672001
g882001
Not applicable
Author

it's not working

it's ok for the present month and month-1 but not for month -2 i don't know why