10 Replies Latest reply: Jul 14, 2015 6:07 AM by Sunny Talwar RSS

    HELP! Can't subtract days from max(date)

      Hi I would really appreciate if someone could help me with a problem I've been stuck on for a while using Qlik Sense:

       

      First i created a variable vLAST_DATE = MAX(DATE);

       

      I have not been able to use it. This worked instead: =Sum({$<DATE={'=MAX(DATE)'}>}SALES) but I don't know how to put my variable in there and I tried many different combinations.

       

      Now the problem is I would like to get a hold of MAX(DATE) - 7 days, just writing MAX(DATE) - 7 does nothing I still get the same MAX(DATE) results.

       

      Ideally I would like to use my variable instead, that way I can create vSECOND_DATE = MAX(DATE) - 7; but any answer that results in giving the right visualization in my bar chart will do. Thanks!

       

      /Sahir