Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I notice your last character is a brace. Should be a parenthesis.
And addition there are some issues as well:
Sum({<[SALES LINE 2.SODate]={">=$(MonthStart(Today()))<=$(MonthEnd(Today()))"}>}[SALES LINE 2.Outstanding Qty_ (Base)])