topic Re: Double variable in QlikView

Double variable

Anonymous — Wed, 01 Apr 2015 09:32:47 GMT

Good morning to everybody,

I have a variable ( MonthStart(Peek('massimo',0,'c'),+1)) that makes a reduction in the loaded table.

Now i need to creation of a new variable (varmod) that change the value of previous variable, like this way:

if(IsNull($varmod),(MonthStart(Peek('massimo',0,'c'),+1))),($varmod))

The problem is that in the process of loading, ($varmod) is not seen as a variable, but as a field, which implies an error because can not find the field ($varmod).

Re: Double variable

sunny_talwar — Wed, 01 Apr 2015 15:44:15 GMT

You have to use it like this:

=if(IsNull($(varmod)),(MonthStart(Peek('massimo',0,'c'),+1))),($(varmod)))

I think this will work.

Best,

Sunny

Re: Double variable

Anonymous — Thu, 02 Apr 2015 07:17:53 GMT

thanks!! it works!!

Re: Double variable

sunny_talwar — Thu, 02 Apr 2015 09:02:26 GMT

I am glad that it worked.

Best,

Sunny