23 Replies Latest reply: Oct 16, 2017 7:25 AM by Sunny Talwar RSS

    Simple Set Expression for two dates

    zahid Rahim

      Dear Qlik Experts,

       

      I want to write a set expression based on two conditions but it is not working. I want to see sum for records which have APPLY_DATE_AT is less than or equal to selected date in a variable (filter date) and TRX_DATE is Greater than previous month and less than the date selected.

       

      Sum(

      {<APPLY_DATE_AT = {"$(='<=' & Date(Max(TRX_DATE)))"}>*<TRX_DATE = {"$(='>=' & Date(AddMonths(TRX_DATE,-1)+1))"}>*<TRX_DATE = {"$(='<=' & Date(TRX_DATE))"}>} AMOUNT_TAKEN

      )


      Regards,


      Zahid Rahim