Discussion Board for collaboration on QlikView Scripting.
I have created a script in Qlikview which contains the field [serial number].
The field should look like this:
My problems is that qlikview losses the zero number for the serial number:
if I need the serial number 1.10 he makes it 1.1 and it is very bad for me (because of duplicates).
Can someone help me please?
Always load the [Serial Number] field with the text() function. That will block QlikView from interpreting the field value as a number. Your values will keep the format that they had upon load/creation.
Load it as text value
text(serials) as new_serials;
Load the value as text. Numerically (which Qv will do by default a the first value is numeric), 1.1 and 1.10 are the same.
text([serial number]) As [serial number],
Try like this : Text(Serial Number) in the script.
Hope this will help you