Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Thanks..This will work..😊
Thanks alot..learned new functions of Qliksense..😊