topic Re: variable in expression in QlikView

variable in expression

Thu, 08 Oct 2015 15:39:17 GMT

Hello,

I have defined a variable in variable overviexw like this ::

Vstart_date = Date(AddMonths([Application date],-1), 'MM-DD-YYYY') .

in the expression : i called this variable

=$(Vstart_date) .

but it's not working ?

thank you in advance

Regards

Re: variable in expression

sunny_talwar — Thu, 08 Oct 2015 15:40:56 GMT

May be try this:

$(=Vstart_date) or

Vstart_date

Re: variable in expression

sunny_talwar — Thu, 08 Oct 2015 15:43:18 GMT

Look over the definition again, do you have just single [Application date] in your application? If not then you probably would need to use a min or max to aggregate all dates to a single date:

Vstart_date = Date(AddMonths(Min([Application date]),-1), 'MM-DD-YYYY')

Re: variable in expression

Gabriel — Thu, 08 Oct 2015 15:46:57 GMT

Hi,

In variable overview window your expression definition should start with = sign