Issue with formating

[varunreddy]

Hi All,

I am struggling in performing sum function as QlikView is not understanding the format.

I have numbers in the below format:

00000000123456

00000003456789.

When I try to add both the numbers I get 0.

Can any one please explain me how to add these two numbers?

Thanks in advance!

Cheers,

Varun Reddy

[sunny_talwar]

Check out this link:

https://gist.github.com/ralfbecher/6550467

[varunreddy]

I cannot open this.

I get this error message:

[sunny_talwar]

Can you try one more time?

Loading numbers in QlikView with more than 14 digits leads into scientific (exponential) notation. T...

[varunreddy]

No luck

[sunny_talwar]

Ralf used a load statement like this:

LOAD Div(Field, 1e10) & left(repeat('0',10), 10 - len(text(Mod(Field, 1e10)))) & Mod(Field, 1e10) as MyNum

[varunreddy]

Will try and update Sunny. Thanks again

Cheers,

Varun Reddy. K