Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

variable

Hello

i have some problems with variables ...

when i write bellow expression in text object it doesn't work:

= DATE1-SendMonth

DATE1 has a number in itself(42389) and sendmonth has 42257

but when i write bellow expression, it work:

= 42389-SendMonth

I would appreciate if anyone knows what's the problem?

1 Solution

Accepted Solutions
oknotsen
Master III
Master III

Is DATE1 a field or a variable?

Based on the title of your topic, I am going to assume a variable.

In that case, try this:

= $(DATE1) - SendMonth

Please note that variable names are Case Sensitive, so maybe you just spelled the variable name wrong.

May you live in interesting times!

View solution in original post

3 Replies
oknotsen
Master III
Master III

Is DATE1 a field or a variable?

Based on the title of your topic, I am going to assume a variable.

In that case, try this:

= $(DATE1) - SendMonth

Please note that variable names are Case Sensitive, so maybe you just spelled the variable name wrong.

May you live in interesting times!
maxgro
MVP
MVP

it should work for a DATE1 variable

for a DATE1 field you need a function (min, max, ...)

Anonymous
Not applicable
Author

Many thanks - it worked perfectly!