Qlik Community

QlikView Connectors

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.
mallikarjun_h
New Contributor III

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

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?  

5 Replies
marcus_malinow
Valued Contributor III

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

Use the Num() function in your load

kuba_michalik
Contributor III

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

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.

Not applicable

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

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
New Contributor III

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

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.

Not applicable

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

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

Community Browser