topic Convert Numeric field to Text in Script in QlikView

Convert Numeric field to Text in Script

Anonymous — Fri, 19 Mar 2010 18:41:03 GMT

We have SKU, which appears in many tables, that are 14 digit numbers (ex: 10071179001233). When exporting to Excel it turns to scientific notation. Is there anyway in the script to convert every occurrence of the SKU field that gets loaded to be converted or CAST to text?

Convert Numeric field to Text in Script

disqr_rm — Sun, 21 Mar 2010 02:00:16 GMT

You can try loading it as Text in the first place:

LOAD text(SKU) as SKU,

...

FROM ....

Then SKU will be loaded as Text file in QlikView dcument itself. Should export to Excel fine then.

Convert Numeric field to Text in Script

Anonymous — Sun, 21 Mar 2010 05:14:55 GMT

Thanks for the reply Rakesh. Yes, that changed it to text but it still went to Excel as a number.

Convert Numeric field to Text in Script

Anonymous — Sun, 21 Mar 2010 05:33:31 GMT

I ended up just using this as the dimension expression in the chart I'm exporting. Not very elegant but it works.

=text(SKU&Chr(32))

Convert Numeric field to Text in Script

disqr_rm — Sun, 21 Mar 2010 13:27:27 GMT

Strange! But atleast you found a workaround. I wouldn't do it in the dimensin though. I would rather create another field ad load it as TEXT(SKU & chr(32)) as SOMETHING, and then use SOMETHING in the dim. That will keep my chart faster atleast.

Convert Numeric field to Text in Script

Anonymous — Sun, 21 Mar 2010 15:20:50 GMT

That didn't work either for some reason. So I just assigned that calculation to a variable and use the variable in each object that I need SKU. Thanks for you help.