Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
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

Re: Color in Pivot Table

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

Re: Color in Pivot Table

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

Re: Color in Pivot Table

Please upload your sample application i will do

Highlighted
Specialist
Specialist

Re: Color in Pivot Table

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

Re: Color in Pivot Table

Hi,

Here is the attached file for your issue.

Regards,

Udit

Highlighted
Not applicable

Re: Color in Pivot Table

thanks so much!!