Skip to main content
Sept. 27, 10AM ET Do more with Qlik, Insight Advisor – our intelligent AI-assistant in Qlik Sense: Register
Showing results for 
Search instead for 
Did you mean: 
Partner - Contributor III
Partner - Contributor III

Load Script BUG - auto convert Text to Number

Hello guys,

Take a look at the simple script below:


LOAD * Inline [


0606110047,Prooduto 1

R606110047,Prooduto 2

0606110050,Prooduto 3



Load * inline [






And The Result is:

CodProd Prod sum(Qtde) sum(Valor)
60 2000
0606110047Prooduto 1301100
0606110047Prooduto 2301100
0606110050Prooduto 330900

The text field value 'R606110047' is auto conveted to '0606110047'.

This is obviously a bug.

And yes, there's a way to fix it. Is to use Text(CodProd).

But we use a qvw to extract, another to transform, and another to show the chart. And I would have to do this in all the qvw files.

And also the field CodProd is used in almost every table.

Another anoying thing, is that we manage all the extract tables within a xls file. And in order to use text(<field>) we have to remove from the excel file and put it direct in the load script. By doing so, we lost our pattern on extract.

Is there a Release that fix this? Is this a known bug? Will it be fixed?

I'm using win7, and Qlikview Desktop 11.20 SR12 64bits


Labels (2)
11 Replies
Partner - Champion III
Partner - Champion III

I consider this a bug too, but there is probably a WAD-like reason to explain this weird behavior.

In the meantime, I'll try to make everyone even more depressed This

SET MoneyFormat='R$ #.##0,00;-R$ #.##0,00';



ID    Spec

1     006060417

2     R006060417

3     R$006060417

4     R$ 006060417

5     R$ 006060417,89

6     R$006060417,89

7     R006060417,89

8     006060417,89

](delimiter is '\t');

produces this as straight table output:

Load script BUG thread 197017.jpg

Money format strings definitely have a license to freewheel...


Partner - Contributor III
Partner - Contributor III

The problem is not the '0' before, is really the money format.

I lost a lot of time with this issue.

I also still think this is a bug.

Anyway, I will change the money format, thats easier.

Thanks all for your time.