Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Highlighted
Partner
Partner

Background colours of pivot table

HI,

I want to add background colours for below pivot table.

See attached image

Is it possible to do?

1 Solution

Accepted Solutions
Highlighted

Re: Background colours of pivot table

Try like this :

Add this in the background colour area of the expressin, it will only format the total row

=if(rowno()=0 or isNull(rowno()),rgb(255,255,0),rgb(255,255,255))


Change the RGB() according to your required color format

View solution in original post

19 Replies
Highlighted
Chanty4u
Esteemed Contributor III

Re: Background colours of pivot table

go to grid style....and  right clik on table  do select custom format cell   and do the font and colur of ur  fields

Highlighted
Chanty4u
Esteemed Contributor III

Re: Background colours of pivot table

chk dis

custm.png

Highlighted

Re: Background colours of pivot table

Try like this >

1.Go to User Preference in the document setting

2.Click on Grid option in the design tab

3.right click on the object >format cell

4.Here you will get all the option to change the color

1.png

2.png

3.png

Highlighted
Partner
Partner

Re: Background colours of pivot table

Here i have use several dimensions and partial sums. That is why i coudn't get the colur variation. I have used custom format cell.

But can't seperate the raws

Highlighted
Chanty4u
Esteemed Contributor III

Re: Background colours of pivot table

can u shre ur sample qvw?

Highlighted
Partner
Partner

Re: Background colours of pivot table

I have marked that.

BUt no difference.

Here i have use several dimensions and partial sums. That is why i coudn't get the colur variation. I have used custom format cell.

But can't separate the raw

Highlighted

Re: Background colours of pivot table

Try like this :

Add this in the background colour area of the expressin, it will only format the total row

=if(rowno()=0 or isNull(rowno()),rgb(255,255,0),rgb(255,255,255))


Change the RGB() according to your required color format

View solution in original post

Highlighted
Chanty4u
Esteemed Contributor III

Re: Background colours of pivot table

chk dis

cu-fr.png

Highlighted
Partner
Partner

Re: Background colours of pivot table

Qvw shared