topic Re: variable in QlikView

variable

Anonymous — Sat, 23 Jan 2016 08:02:06 GMT

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?

oknotsen — Sat, 23 Jan 2016 11:46:30 GMT

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.

maxgro — Sat, 23 Jan 2016 11:54:51 GMT

it should work for a DATE1 variable

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

Anonymous — Sun, 24 Jan 2016 06:14:47 GMT