Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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
Highlighted
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

Highlighted
Not applicable

Please upload your sample application i will do

Highlighted
Specialist
Specialist

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

Highlighted
Creator II
Creator II

Hi,

Here is the attached file for your issue.

Regards,

Udit

Not applicable

thanks so much!!