Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

Tags (3)
2 Replies
agigliotti
Honored Contributor II

Re: How to Convert this Set Expression in Qlikscript

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

jaume_soc
New Contributor

Re: How to Convert this Set Expression in Qlikscript

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.

Community Browser