Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
wanyunyang
Creator III
Creator III

Qlik Sense Variable

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!

4 Replies
Mark_Little
Luminary
Luminary

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

wanyunyang
Creator III
Creator III
Author

Hi Mark, thanks for replying.

How should I call the variables with and without equal sign?

MK9885
Master II
Master II

Without =

wanyunyang
Creator III
Creator III
Author

If I remove =, and do expression like:

Sum({<Date={"<=$(vVariable)"}Sales), it's giving me 0