Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
HWallays
Contributor III
Contributor III

Conversion to numeric with leading zeroes ?

Maybe a silly question, but I have difficulties conversing the below data to numeric data using NUm# or NUm . 

 

000000000000150
000000000000354
000000000000558
000000000000572
000000000000600

 

The above should translate in numeric , resp 

150

354

558

672

600

I used num#(fieldname,'XXX')  but that doesn't do the job and even tried changing the settings (no decimal sign or thousands seperator)  

Guess solution might be simple ... just don't seem to find it 😉 

Labels (2)
1 Solution

Accepted Solutions
hic
Former Employee
Former Employee

Since the numbers have more than 14 digits, they are problematic to interpret using Num#(). But you can do it with Evaluate():

Num(Evaluate(fieldname))

View solution in original post

2 Replies
hic
Former Employee
Former Employee

Since the numbers have more than 14 digits, they are problematic to interpret using Num#(). But you can do it with Evaluate():

Num(Evaluate(fieldname))

HWallays
Contributor III
Contributor III
Author

Thanks Henric this fixex my puzzle indeed  

You saved me quite some investigation time 😉