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

    Sum of quantity where cdate >= d7

    ISHFAQUE AHMED

      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:

      temp:

      Load

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

      Resident sales2015 Group By [date/time];

       

       

      My expression:

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

       

       

      Kind regards,

      Ishfaque Ahmed