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

Announcements
Q&A with Qlik - Qlik Cloud Migration: Questions about migrating to Qlik Cloud? Catch the latest replay!
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.