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

    Help  to convert Set Analysis to variable



      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