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
