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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to truncate 0s at starting of a string and convert it to number

String value 000004567 how to convert this into number 4567. num(String,'#,#'),num#(String,'123456789')

i tried this two.

1 Reply
Clever_Anjos
Employee
Employee

num(num#('000004567'),'#.#')