topic Straight table won't calculate sum in QlikView

Straight table won't calculate sum

Wed, 19 Sep 2012 15:55:45 GMT

I have a report which won't produce the sums at top of the table. Previously, I had a lot of null values, so I went through my SQL script, and used

the coalesce function to turn most of them into zeros. However, some still came through. I used an "IF" statement to convert nulls to zeros, but

they came out as text, not numbers (I checked by exporting into Excel). So now my expressions look like this:

=num(if(isnull(EquipmentCreated),0,EquipmentCreated))

It still won't sum in my straight table, although if I export to Excel, it does work.

Why won't QV do this??

I have attached a couple of files.

Thanks!

MayilVahanan — Wed, 19 Sep 2012 16:09:03 GMT

Please see the attached image.

Hope it helps

Wed, 19 Sep 2012 16:11:37 GMT

It is because of the equation; it shows 'NULL', but you have set it to show '0' instead. You can use Chart Properties > Expressions > Sum of Rows: