Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

maikeoster
New Contributor III

Format the Dimension in a Pivot Table

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.

1 Solution

Accepted Solutions
ali_hijazi
Honored Contributor

Re: Format the Dimension in a Pivot Table

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)) ....

3 Replies
ali_hijazi
Honored Contributor

Re: Format the Dimension in a Pivot Table

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
New Contributor III

Re: Format the Dimension in a Pivot Table

thanks a lot ;-)

Employee
Employee

Re: Format the Dimension in a Pivot Table

Hi Maike

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

='<b>'

Agis

Community Browser