Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. April 17 - 20, 2023, in Las Vegas! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
bvendeza
Contributor II
Contributor II

Please help! MonthEnd Function

I'm unable to post in the Qlikview App Dev forum, so I'm hoping scripting in QlikSense wouldn't be that different.

Can someone please help me with my MonthEnd function?

My values are populating on the first of every month because of my interval, but I would like to move it to the end of each month instead (Note: it's crucial that I have every single day on my chart since I generate daily values for two other fields). I've tried using MonthEnd as well as MonthsEnd, but it just wouldn't work. It either doesn't generate any values, or -if I put the MonthEnd function on line 25 of the LinkTable-, you do get the dates to change to the end of the month, but all other data is removed.  I've tried using different expressions on my chart, but those didn't work either. If ya'll have any suggestions, I'd love to hear them! I've attached a portion of my original  script below (no MonthEnd function included).

Thank you!

1 Reply
MarcoWedel

Maybe

DayName(MonthEnd(InventoryValuation_MBEW.MBEW.YearMonth)) as Date_MAVP.Date

?

see also https://community.qlik.com/t5/QlikView-App-Dev/Any-suggestions-on-how-to-make-MonthEnd-function-work...