topic Re: Formula in a Script Variable in QlikView

Formula in a Script Variable

chriys1337 — Tue, 25 Apr 2017 12:14:05 GMT

Hi,

I am trying to put a formula into a Variable (in the script), but the generator puts out an Script Line Error:

LET vL.FieldSelection_Plus1='=if(right(GetFieldSelections(Selection),2)= '51' or right(GetFieldSelections(Selection),2)= '52', left(GetFieldSelections(Selection),4)+1 &'01',GetFieldSelections(Selection)+1)'; // 2. Kickout, -2 to +1 from Selection

In a Textbox this script works, but how to put it in a variable in the script?

I am happy for any hint.

Kind Regards,

Chris

Re: Formula in a Script Variable

Anil_Babu_Samineni — Tue, 25 Apr 2017 12:18:20 GMT

May be this?

LET vL.FieldSelection_Plus1 = if(right(GetFieldSelections(Selection),2)= '51' or right(GetFieldSelections(Selection),2)= '52', left(GetFieldSelections(Selection),4)+1 &'01',GetFieldSelections(Selection)+1);

Then create text object and use $(vL.FieldSelection_Plus1) and then see

Re: Formula in a Script Variable

sunny_talwar — Tue, 25 Apr 2017 12:18:48 GMT

May be try with SET instead of LET

SET vL.FieldSelection_Plus1 = =if(right(GetFieldSelections(Selection),2)= '51' or right(GetFieldSelections(Selection),2)= '52', left(GetFieldSelections(Selection),4)+1 &'01',GetFieldSelections(Selection)+1);

Re: Formula in a Script Variable

chriys1337 — Tue, 25 Apr 2017 13:03:54 GMT

I did it like you suggested, without '' (comma) and with the SET command. It works in the frontend with a textbox with =vL.FieldSelection_Plus1

Very strange, I thought SET is not computing ... and would need $(), but somehow it works without...