Qlik Community

Ask a Question

New to Qlik Sense

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

Announcements
Join us March 10th, 7 ways modern analytics can help you take smarter action. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
apthansh
Creator
Creator

Number format

I have the below formatted cell..I want to extract numbers after the first 8 digits.I tried the below expression but it is eliminating 0's at the end and also there are some that are getting eliminated in the middle.

mid(Num(Replace(key, ',', '.'), '(dec)'),9) - Output is 1800010

apthansh_0-1598970271782.png

Is there any other work around for this please ?

Thank you much.

 

Labels (6)
3 Replies
Kush
MVP
MVP

try converting it first to text and then extract the string

mid(text(Replace(key, ',', '.')),9) 

or

mid(text(Num(Replace(key, ',', '.'), '(dec)')),9)

 

apthansh
Creator
Creator

Thank you Khush - I tried this, but no luck..output is same as above.

apthansh
Creator
Creator

I have attached the sample file, if that helps.Thank you much.