Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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)])