Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Color in Pivot Table

How can I get a specific row color.  For example I want the 3rd and 6th row of this table to have a background color of Green

1 Solution

Accepted Solutions
udit_kumar_sana
Creator II
Creator II

Hi,

You can try this in background option of dimensions in pivot table.

This you have to put in each dimensions.

=if(rowno()=3 or rowno()=6,rgb(0,127,0))

Regards,

Udit

View solution in original post

5 Replies
udit_kumar_sana
Creator II
Creator II

Hi,

You can try this in background option of dimensions in pivot table.

This you have to put in each dimensions.

=if(rowno()=3 or rowno()=6,rgb(0,127,0))

Regards,

Udit

Not applicable
Author

Please upload your sample application i will do

Anonymous
Not applicable
Author

hi,

please see below lik it will help

http://community.qlik.com/message/160957#160957

also i agree to solution given by udit.

Regards,

anant

udit_kumar_sana
Creator II
Creator II

Hi,

Here is the attached file for your issue.

Regards,

Udit

Not applicable
Author

thanks so much!!