Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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 😉