Format the Dimension in a Pivot Table

[maikeoster]

Hello, I'm new in using QlikView and this Forum.

Can someone tell me how to format the dimensions in a Pivot table? as a function of Content in the dimenson, i want to Format the Background in different colours.

[ali_hijazi · Accepted solution]

click on the + sign and click on the Background; there you can put your conditions:

if(condition istrue, rgb(255,0,0),rgb(255,255,255)) ....

[maikeoster]

thanks a lot 😉

[Agis-Kalogiannis]

Hi Maike

Again on the same place, select the Text Format click Edit and type the following:

='<b>'

Agis