Formatting a calculated dimension pivot table

Thu, 18 Oct 2012 10:57:06 GMT

Hi All,

I am creating a pivot table using two calculated dimensions which (using a number of variables) count the number of records which fall between the variables specified. The table works fine but I now want to format the background colour to specify certain colours depending on the calculated groups.

An extract of the code I have for the dimension calculations is as follows:

Calculated Dimension 1:

= IF(CUMULATIVE_PERCENTAGE <= vKeeper and PROFIT > 0, 'Keeper',

IF(CUMULATIVE_PERCENTAGE > vKeeper and CUMULATIVE_PERCENTAGE <= vMaintainer, 'Maintainer'))

Calculated Dimension 2:

= IF(Percent_Weeks_Sold >= vRunner, 'Runner',

Percent_Weeks_Sold < vRunnerand Percent Weeks_Sold >= vRepeater, 'Repeater'))

= IF(

My expression is a simple count ( =Count(product) of all products which fall into each of these calculated categories.

The pivot table produced looks as follows:

	Runner	Repeater
Keeper	10	20
Maintainer	30	15

I now want to format the value cells, for example the cell relating to keeper/runner = lightgreen(), keeper/repeater = lightblue(), maintainer/repeater = lightred() etc.

Does anyone know how I can set the colour formatting to colour the cells in line with the calculated dimension?

Many thanks,

Chris

topic Formatting a calculated dimension pivot table in QlikView

Formatting a calculated dimension pivot table