If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I have created a variable in the load script as Follow;
Let vForecastDate = $(vMaxDate)+ 5;
My vMaxDate = Oct-2020, and the expected answer is Nov-2020, Dec-2020, Jan-2021, Feb-2021. But I am getting the answer as 44106, 44107,44018.
I tried several options to convert the above variable into MonthName, but it does not work,
Please advise on the above.
Dates are stored internally as number of Days. So "+5" advances the date by 5 days, not 5 months. You can see the formatted date value by wrapping a Date() function around your expression:
What you want is the AddMonths() function:
View solution in original post
Thanks for the solution, it is working perfectly.