Solved: Re: Issue with formating - Page 2 - Qlik Community

varunreddy · ‎2016-10-19

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 · ‎2016-10-24

Check out this link:

varunreddy · ‎2016-10-24

I cannot open this.

I get this error message:

sunny_talwar · ‎2016-10-24

Can you try one more time?

varunreddy · ‎2016-10-24

No luck

sunny_talwar · ‎2016-10-24

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 · ‎2016-10-24

Will try and update Sunny. Thanks again

Cheers,

Varun Reddy. K