Preventing QV from showing partials sums for certain columns (e.g. dates)

Sat, 07 May 2011 21:49:08 GMT

Problem

QlikView attemps to list partials sums for all columns, including dates (as shown in the attached image) even though partials sums are not relevant for this data type.

Chart Setup

I'm using a pivot table to show several projects based on categorization. I have a column that is a dollar amount, and I therefore enabled partials sums for the pivot table.

Questions

1. Is it possible to prevent QlikView from presenting partials sums for some expressions?

2. Also, it'd be ideal to prevent the gray shading from extending beyond the cost column. Is that possible either?

Thanks for your feedback!

Preventing QV from showing partials sums for certain columns (e.g. dates)

stevedark — Sat, 07 May 2011 23:14:24 GMT

Hi there,

If you expand the data expressions with the + symbol you should be able to set the background colour expression to rgb(255, 255, 255) and that should make those columns white regardless of what level they are at.

To suppress the totals appearing for the date columns you probably want to explore the SecondaryDimensionality function (see the help text for details). With this you should be able to put in an if statement that suppresses the totals.

Hope that helps.

Regards,

Steve

topic Preventing QV from showing partials sums for certain columns (e.g. dates) in QlikView

Preventing QV from showing partials sums for certain columns (e.g. dates)

Preventing QV from showing partials sums for certain columns (e.g. dates)