Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
anindya_manna
Creator II
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
MVP
MVP

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

The Power of shining a light on the dark side of your data.
Follow me on my LinkedIn | Know Gamma Informatica at gammainformatica.it
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.