topic Re: Serial Number problem in QlikView

Serial Number problem

Anonymous — Tue, 30 Jun 2015 07:44:50 GMT

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.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

Re: Serial Number problem

Peter_Cammaert — Tue, 30 Jun 2015 07:49:02 GMT

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

Re: Serial Number problem

avinashelite — Tue, 30 Jun 2015 07:50:26 GMT

Load it as text value

try like

load *,

text(serials) as new_serials;

Re: Serial Number problem

jonathandienst — Tue, 30 Jun 2015 07:50:59 GMT

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

...

Re: Serial Number problem

prajapatiamar38 — Tue, 30 Jun 2015 07:51:51 GMT

Hii

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

Hope this will help you

Thanks