topic Re: Using Variable in For .. Next in QlikView

Using Variable in For .. Next

Fri, 19 Jul 2013 08:11:43 GMT

Ho Guys

I have declared the Variable in the Back End Like Below:

Let _vYear = '=Year(Max(Today()))';

Now i want to use the above variable in my For Next statment :

For i = 2005 to $(_vYear)

But it is not working ....

Is there any other way to achieve the above :::::

alexandros17 — Fri, 19 Jul 2013 08:16:26 GMT

Let _vYear = Year(Today());

For i = 2005 to $(_vYear)

...

Next

hope it helps

hic — Fri, 19 Jul 2013 13:29:27 GMT

You don't even need the $-expansion. The following should also work:

Let _vYear = Year(Today());

For i = 2005 to _vYear

...

Next i

HIC

Fri, 19 Jul 2013 13:39:04 GMT

try this

Let _vYear = Year(Today());

For i = 2005 to $(_vYear)

...

Next i