10 Replies Latest reply: Feb 21, 2015 4:45 AM by ISHFAQUE AHMED RSS

    Sum of quantity where cdate >= d7


      Dear All,


      I would like to calculate sum of quantity where cdate >= d7.


      I'm going to achieve my required result through following script and expression in Qlik Sense, but given below expression is returning Zero "0" value.


      Please make correction, and share me expression.


      My script:



           date(Max([date/time])-6) as d7

      Resident sales2015 Group By [date/time];



      My expression:

      sum({<cdate = {'>=[d7]'}>} quantity)



      Kind regards,

      Ishfaque Ahmed