Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Formatting a calculated dimension pivot table

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:

RunnerRepeater
Keeper1020
Maintainer3015

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

0 Replies