Addition of a varible in a Crosstable

[#1]

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

[swuehl]

After your crosstable load, L_Z1V1 is just a field value in field Linie_niO, isn't it?

So it's a string value and using something like

L_Z1V1 + Offset

can't work.

Maybe you want to add the Offset to Wert_niO?

Could you upload a small sample?

[#3 · Accepted solution]

If I add the Offset to Wert_niO, nothing changes... It changes the way I want when I change the dimension to:

Class(Wert_niO + Offset, 0.001).

The thing is that I cannot plot both lines at the same time... Can you help me? Sorry but I cannot upload a small sample because of my qlikview version.

Thank you very much for your help!!!!

Eduardo