=Num#('000000000000002389') not working

[thkarner]

Hi,

interesting thing. I´ve SAP material numbers, e.g. 000000000000002389

Data is retrieved as text which I want to convert, but wasn´t sucessful.

Then I tried to use a KPI object and saw that this

=Num#('00000000002389')

is working, but the following not.

=Num#('000000000000002389')

Has anybody an explanation?

Regards,

Thomas

[sunny_talwar · Accepted solution]

QlikView is unable to read a number greater than 14 digit as a number

[sunny_talwar]

May be remove leading zeros before using Num#() function

QlikView Addict: Removing Leading Zeros

[swuehl]

If your significant digits are below 15, hence there are just leading zeros padded, you can try like

LOAD *, Num(TestNum) as TestNumNoLeadingZeros;

LOAD *, Evaluate(TEST) as TestNum INLINE [

TEST

000000000000000123

000000000000233455

];