5 Replies Latest reply: Nov 29, 2012 2:39 AM by eduqlikview RSS

    Adding a Variable in Script

      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