Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

meitargold
New Contributor III

Serial Number problem

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

4 Replies

Re: Serial Number problem

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

Load it as text value

try like

load *,

text(serials) as new_serials;

MVP
MVP

Re: Serial Number problem

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

     ...

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
prajapatiamar38
Contributor II

Re: Serial Number problem

Hii

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

Hope this will help you

Thanks

Community Browser