Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: 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
Employee
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
Employee
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 😉