topic Re: How to convert number to string in QlikView

How to convert number to string

Tue, 28 Oct 2014 12:44:56 GMT

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

jpenuliar — Tue, 28 Oct 2014 12:47:31 GMT

see if this is you need.

salto — Tue, 28 Oct 2014 12:48:40 GMT

Hi,

try with Text(Trim(Field))

Hope this helps.

Tue, 28 Oct 2014 12:48:58 GMT

Hi,

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

alexandros17 — Tue, 28 Oct 2014 12:49:11 GMT

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

Anonymous — Tue, 28 Oct 2014 12:52:00 GMT

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

Tue, 28 Oct 2014 12:57:47 GMT

Hi,

try this

Text(field value)