Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Chart with null row

@ ! !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:tableNon.bmp

table.bmp

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

1 Solution

Accepted Solutions
Not applicable

Re: Chart with null row

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

SET DecimalSep=',';

To

SET DecimalSep='.';


16 Replies

Re: Chart with null row

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

this will eliminate the top null value

jonasheisterkam
Contributor III

Re: Chart with null row

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

Re: Chart with null row

exp.png

Not applicable

Re: Chart with null row

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?

Not applicable

Re: Chart with null row

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

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

Not applicable

Re: Chart with null row

The expression is simple:

=Free+50

Re: Chart with null row

we can cannot guess the issue by this :

please post the app

jonasheisterkam
Contributor III

Re: Chart with null row

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

Community Browser