topic How to convert the text data into number after loading into QlikView? in QlikView

How to convert the text data into number after loading into QlikView?

mallikarjun_h — Mon, 26 Jan 2026 21:26:37 GMT

I have extracted data from data source using SAP extractor connector. But then I find that the data is in text form although it is a number. Is there any way I can convert data type of these texts into numbers?

Re: How to convert the text data into number after loading into QlikView?

marcus_malinow — Thu, 22 Jan 2015 09:44:29 GMT

Use the Num() function in your load

Re: How to convert the text data into number after loading into QlikView?

kuba_michalik — Thu, 22 Jan 2015 09:50:41 GMT

If it didn't convert automatically, use Num#() function at load, it interprets text as numbers in a specified format.

If for whatever reason you can't do it at load, you can even use Num#() in the chart expression (but that's likely to be very slow if you are going to need to agregate the result in any way).

Don't use Num(), that one is formatting something that is already a number.

Re: How to convert the text data into number after loading into QlikView?

Thu, 22 Jan 2015 09:54:18 GMT

Hi Prasad,

if the value is a string you will need to use Num#() and not Num() in your load.

Have a look at the below for a few examples of the different use cases
http://community.qlik.com/message/156115#156115

http://community.qlik.com/message/538561#538561

hope that helps

Joe

Re: How to convert the text data into number after loading into QlikView?

mallikarjun_h — Thu, 22 Jan 2015 11:05:55 GMT

Hi Joe,

thanks for the information.

But I need to extract data from SAP infocubes so every time we need to do this or there is some setting can be done at the extraction level.

Re: How to convert the text data into number after loading into QlikView?

Thu, 22 Jan 2015 12:01:54 GMT

You would need to use the num#() function in your extract script yes, to adjust the field during the load