2 Replies Latest reply: Feb 14, 2018 12:47 PM by Digvijay Singh RSS

    Issue with getting prior year to date calculation

    Chekib Kchouk

      Is there anything wrong with the following Qlik Sense Expression?


      Sum({$<[Fiscal Year]={$(=vMaxFY-1)}, [Fiscal Date]={"<=$(vMaxFiscalDatePY)"}>} [Actual Amt])


      I have tested the vMaxFY and vMaxFiscalDatePY and they both return the right values:


      I am getting all zeros.When I replace the vMaxFiscalDatePY with the actual date, I get values. Any ideas?