topic Re: Using a variable in a set statement in QlikView

Using a variable in a set statement

Wed, 03 Jun 2015 08:26:03 GMT

Hi all,

I could really use some help with making a script dynamical so that i wouldnt have to change it each year.

I created a variable named: vCurrentYear that defines the year in which we currently live.

Now im trying to substitute the 2015 into the formula but when i try it stops working?

SET fClaims_Jan_CY =

if(Conditiemutatie_Vanaf >= Date#('01-01-2015')

for example:

SET fClaims_Jan_CY =

if(Conditiemutatie_Vanaf >= Date#('01-01-($(vCurrentYear))') (Doesnt work)

pokassov — Wed, 03 Jun 2015 08:30:51 GMT

Hi!

if(Conditiemutatie_Vanaf >= Date#('01-01-$(vCurrentYear)')

Gysbert_Wassenaar — Wed, 03 Jun 2015 08:33:54 GMT

You don't need that variable actually:

SET fClaims_Jan_CY = InYear( Conditiemutatie_Vanaf , today());