Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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?
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