Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

larisa_filonova
Contributor II

background colour in a cross-table

Hi,

I'm trying to set a background colour for a dimension in a cross-table. But I don't want this colour to affect the total Column.

How is it possible?

I don't see a possibility to set a background colour separately for normal columns and a total column. If I set a colour, it affects all columns.

Thank you in advance,

Larisa

1 Solution

Accepted Solutions
stigchel
Honored Contributor

Re: background colour in a cross-table

In the dimensions tab expand the options of the dimension by clicking on the plus sign in front of it. In background color use the following expression:

=if(Rowno()>0,rgb(0,100,0))

BGDimensionExTotal.png

2 Replies
stigchel
Honored Contributor

Re: background colour in a cross-table

In the dimensions tab expand the options of the dimension by clicking on the plus sign in front of it. In background color use the following expression:

=if(Rowno()>0,rgb(0,100,0))

BGDimensionExTotal.png

larisa_filonova
Contributor II

Re: background colour in a cross-table

Thank you!

Community Browser