Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jusrober
New Contributor II

I need to convert a number into text with a certain format

Hello,

I  need to convert a number into text with a certain format.

ex 123 ->00123

    3345 ->03345

thanks in advance

1 Solution

Accepted Solutions
oknotsen
Honored Contributor III

Re: I need to convert a number into text with a certain format

I assume you only need to change the looks of it?

If so, you can do this by using the NUM() function with the right format.

Num - script and chart function ‒ Qlik Sense

May you live in interesting times!
2 Replies
oknotsen
Honored Contributor III

Re: I need to convert a number into text with a certain format

I assume you only need to change the looks of it?

If so, you can do this by using the NUM() function with the right format.

Num - script and chart function ‒ Qlik Sense

May you live in interesting times!
jusrober
New Contributor II

Re: I need to convert a number into text with a certain format

More or less. Thanks for the help!