topic Suppressing Column Totals on Pivot Table in QlikView

Suppressing Column Totals on Pivot Table

tmumaw — Thu, 15 Sep 2011 14:37:56 GMT

Hi All, I think I already know the answer but I thought I would ask. I am using a pivot table to show by customer, sales order and service the total dollar value,

number ordered. I want to show the total dollar value, but not the total number ordered because it makes no since. Is there a way to suppress the total for number ordered and still have a total dollar value of the sales order? From reading the different posts I think I'm out of luck.

Thanks

Suppressing Column Totals on Pivot Table

Thu, 15 Sep 2011 15:29:05 GMT

I assume you are talking about the totals that show when using 'partial sums'?

How about rather than using the expression:

sum([number ordered])

you use instead:

if (rowno() <> 0, sum([number ordered])

where in this context rowno() returns the row number in the current column segment and so is 0 when its a total line.

If you have partial sums at the lowest dimension level (ie you have a 'grand total' line) and you want to suppress that too use instead:

if (rowno() <> 0 and rowno(TOTAL) <> 0, sum([number ordered])

Regards,

Gordon

Suppressing Column Totals on Pivot Table

tmumaw — Thu, 15 Sep 2011 15:55:19 GMT

Thanks Gordon. This exactly what I wanted to do.....I know anything is possible with QlikView, you just need to find out how to do it.