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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Date Range filter

Hey Guys,

I am new to Qlik. I am trying to add date range filter to find the current month data as below but it doesnt work. Could you please take a look at it and let me know  what the problem is? I guess I am missing something on the expression..

SUM( {<[SALES LINE 2.SODate]={'>= (MonthStart(Today()))<=(MonthEnd(Today()))'}>}[SALES LINE 2.Outstanding Qty_ (Base)]}

Thanks

Sonay

2 Replies
m_woolf
Master II
Master II

I notice your last character is a brace. Should be a parenthesis.

sunny_talwar

And addition there are some issues as well:

Sum({<[SALES LINE 2.SODate]={">=$(MonthStart(Today()))<=$(MonthEnd(Today()))"}>}[SALES LINE 2.Outstanding Qty_ (Base)])