5 Replies Latest reply: Oct 27, 2016 8:09 AM by m ellis RSS

    Help  to convert Set Analysis to variable

    m ellis

      Hi

       

      I have the following  code which works fine within Qliksence:

       

      Sum({<SaleDate={"$(=Date(Max(SaleDate),'YYYY-MM'))-*"},SaleFiscalYear=,SaleYear=, SaleMonth=>} Sales)

       

      As this is used a number of times and subject to change I would like to store it as a variable within the script. However is  fails to return anything. Can someone help the the formatting please. I think the single v double quotes and Chr(36) $ is the culprit here.

       

      Many Thanks