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: 
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
MVP
MVP

And addition there are some issues as well:

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