topic Re: Chart with null row in QlikView

Chart with null row

Wed, 04 Feb 2015 11:47:19 GMT

@ ! !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).

Re: Chart with null row

avinashelite — Wed, 04 Feb 2015 11:49:04 GMT

Go to >expression> select > total mode>NO total

this will eliminate the top null value

Re: Chart with null row

jonasheisterkam — Wed, 04 Feb 2015 11:49:49 GMT

Can you Upload a sample file? Coud it be the Total row(), have you deactivate Total on the expressions?

Re: Chart with null row

avinashelite — Wed, 04 Feb 2015 11:50:32 GMT

Re: Chart with null row

Wed, 04 Feb 2015 12:14:42 GMT

Thanks for the help, I could remove the header, however the column which just adds 50 to Free still doesnt work and gives me nulls, any ideas?

Re: Chart with null row

Wed, 04 Feb 2015 12:16:22 GMT

Yes, I think it was that. But do you know why the columns where I just add 50 to the last column it gives me nulls as the picture above shows? The first line is removed, but I cant calculate the sum of Free+50 on the expression of the last column it still gives nulls numbers.

Re: Chart with null row

avinashelite — Wed, 04 Feb 2015 12:18:51 GMT

can please share the expression or app ?/ so that we can check

Re: Chart with null row

Wed, 04 Feb 2015 12:25:18 GMT

The expression is simple:

=Free+50

Re: Chart with null row

avinashelite — Wed, 04 Feb 2015 12:27:16 GMT

we can cannot guess the issue by this :

please post the app

Re: Chart with null row

jonasheisterkam — Wed, 04 Feb 2015 12:33:11 GMT

In Youre case Free might be a Text or have you define that it be written on the left side.

Re: Chart with null row

Wed, 04 Feb 2015 12:47:31 GMT

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

Re: Chart with null row

Wed, 04 Feb 2015 12:54:12 GMT

I already update the first post with it. Thanks

Re: Chart with null row

Wed, 04 Feb 2015 13:07:01 GMT

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

Re: Chart with null row

avinashelite — Wed, 04 Feb 2015 13:12:41 GMT

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

Re: Chart with null row

Wed, 04 Feb 2015 13:13:54 GMT

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

SET DecimalSep=',';

SET DecimalSep='.';

Re: Chart with null row

Anonymous — Wed, 04 Feb 2015 13:24:31 GMT

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

Re: Chart with null row

Wed, 04 Feb 2015 17:18:11 GMT

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