Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm confused about Qlik Sense Variable:
If I do: AddMonths(Today(),-12), it shows me 10/24/2018.
If I do :=AddMonths(Today(),-12) , it shows me 12/30/2899.
Any idea on this? Thanks in advance!
Hi,
It is all down to the evaluation of the variable.
If you add = in the variable it evaluates the what's in the variable and returns the result.
without just returns whats in the variable.
This is then added to on how you call the variable in the front $(vVariable) or vVariable.
Mark
Hi Mark, thanks for replying.
How should I call the variables with and without equal sign?
Without =
If I remove =, and do expression like:
Sum({<Date={"<=$(vVariable)"}Sales), it's giving me 0