topic Re: Variable in Scripts in QlikView

Variable in Scripts

Fri, 28 Sep 2012 13:40:38 GMT

I have created a variable in back end like

Let _Var = '=GetFieldSelections(Num_Month)';

Now i want to use it in my Load statement for example like below:

Load

ID,

Num_Month,

if($(_Var) = Num_Month,'Match','Not Match') as _Status

From Excel........

But i am not getting the desired result .....????

Is it possble to use it like this ..........???

please help

Re: Variable in Scripts

Anonymous — Fri, 28 Sep 2012 13:45:48 GMT

Hi manish05,

To use a variable, you have tu put it into $(), in your exemple:

Load

ID,

Num_Month,

if( $(_Var) = Num_Month,'Match','Not Match') as _Status

but as you have initialized your variable before the load, I suppose you the condition you want is:

if( Num_Month= $(_Var),'Match','Not Match') as _Status

Re: Variable in Scripts

Fri, 28 Sep 2012 13:51:04 GMT

Still Not working

Re: Variable in Scripts

jonathandienst — Fri, 28 Sep 2012 13:59:17 GMT

Using a Let statement produces a string. So the variable expands to the string. Change that to a set without the quotes:

Set _Var = =GetFieldSelections(Num_Month);

(the double = signs are not a typo!)

This will produce a variable whose value is the field selection. I that what you are expecting?

Hope that helps

Jonathan

Re: Variable in Scripts

Anonymous — Fri, 28 Sep 2012 13:59:58 GMT

What is the complete script? Does the filed Num_Month exists in your excel file?

Actually, the function GetFieldSelections() is not available to be used in the script, so if you use GetFieldSelections() to set the variable in the script it won't work.

Re: Variable in Scripts

jonathandienst — Fri, 28 Sep 2012 14:01:03 GMT

But that will not produce useful value when used here.

If($(_Var) = Num_Month,'Match','Not Match') as _Status

What are you trying to compare with Num_Month?

Jonathan

PS and bobbyraj is right, GetFieldSelections does not work in script

Re: Variable in Scripts

Fri, 28 Sep 2012 14:16:02 GMT

But when i am using _Var in front end in the Text Obejct it is giving me the correct result , then why i can not use it in back end just below few lines after declaring the variable