topic Re: Char to num coversion in QlikView

Char to num coversion

Fri, 08 Mar 2013 11:54:55 GMT

Hi,

I have a number as a character 1.25 and I need to sum all data. How do I convert this char to a number in my script?

num() gives a - in stead of a number.

Greetings,

Ruud

Gysbert_Wassenaar — Fri, 08 Mar 2013 12:00:40 GMT

Use the num# function. It takes a string and you can specify the format so the string can be made a number.

manideep78 — Fri, 08 Mar 2013 12:00:54 GMT

No problem. No need to convert that into number. QlikView automatically treats it as a Number. QlikView doesn't have data types.

Still you are facing any probelm use Num#() function.

refer help for this.

Fri, 08 Mar 2013 13:00:45 GMT

num#(1.25, '#.##') did the trick where 1.25 is a value of a datafield called Uren -> formula: num#(Uren, '#.##')

Thanx all!