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

[mallikarjun_h]

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?  

[marcus_malinow]

Use the Num() function in your load

[kuba_michalik]

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.

[#4]

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

[mallikarjun_h]

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.

[#6]

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