Serial Number problem

[Anonymous]

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

[Peter_Cammaert]

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

[avinashelite]

Load it as text value

try like

load *,

text(serials) as new_serials;

[jonathandienst]

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],

     ...

[prajapatiamar38]

Hii

Try like this : Text(Serial Number) in the script.

Hope this will help you

Thanks