topic Re: Pivot table RangeSum() with a strange row at the bottom in QlikView

Pivot table RangeSum() with a strange row at the bottom

Anonymous — Tue, 09 Jun 2015 11:35:13 GMT

Hi, all,

Today I see a strange behavior of pivot table when using RangeSum() (also RowNo()) to calculate the data as in the attached snapshot.

When I add the third expression "=sum(Spend)", there is a line suddenly appears at the bottom of the table "Revenue 1", and before that, the table is as "Revenue 2". I do not need this row, but do not know how to get rid of it. Dose any one have any clue?

Thanks very much

Re: Pivot table RangeSum() with a strange row at the bottom

sushil353 — Tue, 09 Jun 2015 11:36:47 GMT

In Dimension > suppress null values.

HTH

Sushil

Re: Pivot table RangeSum() with a strange row at the bottom

jonathandienst — Tue, 09 Jun 2015 11:44:11 GMT

You most likely have a record that is missing the date, possibly caused by a faulty join in your load script or a problem with your source data. If you are satisfied that this does not represent real data, you can suppress nulls as the previous poster suggested.

A better solution is to trace where these records are coming from and work to eliminate them from your model, or to correct them with a valid date.

Re: Pivot table RangeSum() with a strange row at the bottom

Anonymous — Tue, 09 Jun 2015 11:46:51 GMT

Hi, Sushil,

Thanks very much, it works!!!

Re: Pivot table RangeSum() with a strange row at the bottom

Anonymous — Tue, 09 Jun 2015 11:48:46 GMT

Hi, Jonathan,

Yes, I think you are correct, I think the expression "sum(Spend)" calculated some other data has no date.

Thanks very much for the suggestion