2 Replies Latest reply: Nov 27, 2012 3:42 AM by eduqlikview RSS

    Addition of a varible in a Crosstable

      Hey!!

      ´

      I have the following Crosstable in my script.

       

      Verteilung:

      Crosstable (Linie_niO, Wert_niO, 17)

      LOAD Datum,

        Year (Datum) as Jahr,

        Month (Datum) as Monat,

        Day (Datum) as Tag,

        Hour (Datum) as Stunde,

        Minute (Datum) as Minute,

        Date(floor(Datum),'DD/MM/YYYY') as DatumTag,

        recno() as RecordNumber, //Spalte mit 1 2 3 4 etc

           Motortyp,

           Testserie,

           BestellNr,

           SerialNr_ZKL,

           SerialNr_ZKR,

           OA_0_5,

           OA_1_0,

           OA_1_5,

           OA_2_0,

           L_Z1V1,

           L_Z1V2,

           L_Z2V1,

           L_Z2V2,

           L_Z3V1,

           L_Z3V2,

           L_Z4V1,

           L_Z4V2

      FROM

      [aktuell_SPC_Daten.xlsx]

      (ooxml, embedded labels, table is Iprozer);

       

      With this Crosstable I plot 8 Gauss-bells (L_Z1V1...L_Z4V2). Dimension: Class(Wert_niO, 0.001) // Expression: Count(Wert_niO)

       

       

      The problem is that I would like to plot other 8 Gauss-bells with same values but simply with an offset addition. This Offset schould be a variable that could be changed in Qlikview with an Inputbox. I thought about to add

       

      L_Z1V1 + Offset;

       

      But it doesn't work because the lines dont change when I change the value of Offset...

       

       

      Thank you very much!!!!!

       

      Eduardo