Chart with null row

[#1]

@ ! !Hello everyone,

I am creating a chart table (pivot table) but there is a row with a null value I dont know why.

If I dont upload any data it gives me this result:

And if I do (load data) this line keep there:

I guess the problem is in the creating of chart I not in the script.
My dimensions are Day and Volume. Because of this simple problem when I make another column to just add 50 to free (the column Free+50) it gives null in every row.

Do you have any ideas? Or any guesses where the problem is?

PS. On my fields there arent no null fields (that's why I think the problem is on the setup of the chart and not in the script to load the data).

[#2]

I already update with the qvd file. Please if you are going to edit it, tell me the instructions. I am not able to open avd, since I stillo dont have a qlikview license.

Thanks in advance

[#3]

I already update the first post with it. Thanks

[#4]

At your QVW configuration your decimal separator is , (comma) and when you load your data you are using . (point), so to QlikView recognize as a number, at Load script you need use Replace(Free,'.',',') or at your field at table use:

Free

=Replace(Free,'.',',')

Free+50

=Replace(Free,'.',',')+50

Jean Filipe Delle

[avinashelite]

hi

the Free field is in string format hence your not able to add 50 for it .

in the script convert Free filed to number as below

num#(Free, '#,##0.00') as Free

then try with your expression that should work, i am not able to reload ur document

[#6 · Accepted solution]

Or just change the initialised variable from a comma to a point.

SET DecimalSep=',';

To

SET DecimalSep='.';

[Anonymous]

Hi

Something is wrong with your data ,

Free field may not be in number format.

I just stored your table in csv file and reload it.

See the attached qvw with addition of Free + 50

[#8]

Thanks to all! That was the problem. I had to replace the . to ,