Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

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)]}



2 Replies
Honored Contributor II

Re: Date Range filter

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

Re: Date Range filter

And addition there are some issues as well:

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

Community Browser