2 Replies Latest reply: Mar 1, 2016 1:02 PM by Sunny Talwar RSS

    Date Range filter

    Sonay Yazici

      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