Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have created a script in Qlikview which contains the field [serial number].
The field should look like this:
1
1.1
1.1.1
1.2.1
1.2.2
.......
1.10
1.10.1
1.10.2
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?
Thanks
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.
Peter
Load it as text value
try like
load *,
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.
Like this:
LOAD ....
text([serial number]) As [serial number],
...
Hii
Try like this : Text(Serial Number) in the script.
Hope this will help you
Thanks