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

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. Learn More!
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..😊