topic Re: Adding a Variable in Script in QlikView

Adding a Variable in Script

Tue, 20 Nov 2012 09:59:21 GMT

Hey!

I have the following script:

Offset_in_Hub=0.1

Verteilung_Verschoben:
Crosstable (Linie_niO_Verschoben, Wert_niO_Verschoben, 1)
LOAD Datum,
     L_Z1V1,
     L_Z1V2,
     L_Z2V1,
     L_Z2V2,
     L_Z3V1,
     L_Z3V2,
     L_Z4V1,
     L_Z4V2,
     L_Z1V1+Offset_in_Hub,
     L_Z1V2+Offset_in_Hub,
     L_Z2V1+Offset_in_Hub,
     L_Z2V2+Offset_in_Hub,
     L_Z3V1+Offset_in_Hub,
     L_Z3V2+Offset_in_Hub,
     L_Z4V1+Offset_in_Hub,
     L_Z4V2+Offset_in_Hub

FROM
[aktuell_SPC_Daten.xlsx]
(ooxml, embedded labels, table is Iprozer);

The thing is that Qlikview doesn't understand that "Offset_in_Hub" is a Variable that I just defined. It works when I write a constant (like 0.1) instead of my variable, but this Offset must be variable with a Inputbox.

Thank you very much!!!

Eduardo

Re: Adding a Variable in Script

Anonymous — Tue, 20 Nov 2012 10:00:26 GMT

Try:

SET Offset_in_Hub=0.1;

Re: Adding a Variable in Script

Anonymous — Tue, 20 Nov 2012 10:00:47 GMT

And call it using $(Offset_in_Hub)

Re: Adding a Variable in Script

Tue, 20 Nov 2012 10:08:58 GMT

Thank you vey much Johannes! It works perfectly. But I just realized that even if I change the value of "Offset_in_Hub" with an Inputbox, my data doesnt change till I run the skript again.

What I plot the following chart with these datas:

Dimension: =Class(Wert_niO_Verschoben, 0.001)

Expression: =Count(Wert_niO_Verschoben)

Can you please help me??

Thank you!!

Eduardo

Re: Adding a Variable in Script

Tue, 20 Nov 2012 10:40:51 GMT

Thank you for your help but it doesnt work...

What I plot are Gauss bells. For every L_ZXVY I plot a Gauss bell. I would like to plot these sames Gauss bells but with a offset that I can change with an Inputbox (and without running the script again...).

Do you have any idea??

Thank you for your time and effort!

Eduardo

Re: Adding a Variable in Script

Thu, 29 Nov 2012 07:39:50 GMT

Finally I put the offset in the dimension and it worked as I wanted!

Eduardo