Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
QlikView is unable to read a number greater than 14 digit as a number
QlikView is unable to read a number greater than 14 digit as a number
May be remove leading zeros before using Num#() function
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
];