Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
MTD:sum({$<[Process Date]={">=$(=MonthStart(Max([Process Date]))) <=$(=Max([Process Date]))"}, [Week ID]=>}[Sales Amt])
How to convert this above set expression in qlikscript so that I can write in load script??
if your expression related to the current user selections, you can't I guess.
There are actually many questions like your one:
Today,YTD and MTD in Qlikview Script
Re: Month to date (MTD) in loading script
maybe their answers can help you.