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!
