topic Color in Pivot Table in QlikView

Color in Pivot Table

Thu, 14 Mar 2013 21:53:27 GMT

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

udit_kumar_sana — Fri, 15 Mar 2013 06:20:06 GMT

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

Fri, 15 Mar 2013 06:49:02 GMT

Please upload your sample application i will do

Anonymous — Fri, 15 Mar 2013 06:57:53 GMT

hi,

please see below lik it will help

also i agree to solution given by udit.

Regards,

anant

udit_kumar_sana — Fri, 15 Mar 2013 08:36:11 GMT

Hi,

Here is the attached file for your issue.

Regards,

Udit

Fri, 15 Mar 2013 12:25:11 GMT

thanks so much!!