Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
anindya_manna
Partner - Creator II
Partner - Creator II

How to Convert this Set Expression in Qlikscript

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??

2 Replies
agigliotti
Partner - Champion
Partner - Champion

if your expression related to the current user selections, you can't I guess.

jaume_soc
Contributor II
Contributor II

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.