Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

How to convert number to string

Hi Friends,

I have one column with values 01,02,03,87,89,98etc

I want to use match function. How to convert these numbers to string so that It will be easy for me to comparision.

Thanks

Pavan

Tags (1)
1 Solution

Accepted Solutions
gabriel_kirst
Contributor III

Re: How to convert number to string

Hello

You can use text(number_field) to convert it to string.

If you want this number with the zeros in the left, you can use text(num(number_field,'00')). This way will keep, for example, "01".

Hope it helps.

Regards,

Gabriel

6 Replies
jpenuliar
Valued Contributor III

Re: How to convert number to string

Numeric to string

see if this is you need.

salto
Valued Contributor II

Re: How to convert number to string

Hi,

try with Text(Trim(Field))

Hope this helps.

Not applicable

Re: How to convert number to string

Hi,

you can use text(field) then the values will be converted to string.

Re: How to convert number to string

If you have 01 you have yet a value in string format, try to add more details to your request

gabriel_kirst
Contributor III

Re: How to convert number to string

Hello

You can use text(number_field) to convert it to string.

If you want this number with the zeros in the left, you can use text(num(number_field,'00')). This way will keep, for example, "01".

Hope it helps.

Regards,

Gabriel

Not applicable

Re: How to convert number to string

Hi,

try this

Text(field value)

Community Browser