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: 
salmankojar
Partner - Creator II
Partner - Creator II

Converting Number Stored in a text format to a number format

i am working with a project which have a field containing item code such as '000000000000010000' in this text format and i am trying to convert this into number format using this statement 

NUM(NUM#("item code"))

But the above statement gives null values.it doesnt convert the field value.

i tried TRIM function also but it still remains the same.

i have attached an image of it for reference.

Please help me..

Thankyou.

Screenshot 2023-05-08 160122.png

Labels (4)
21 Replies
salmankojar
Partner - Creator II
Partner - Creator II
Author

Thanks..This will work..😊

salmankojar
Partner - Creator II
Partner - Creator II
Author

Thanks alot..learned new functions of Qliksense..😊