topic custom row colors in pivot table in QlikView

custom row colors in pivot table

Tue, 30 Sep 2014 08:47:08 GMT

Hi Guys,

I want to change a color in particular entire row in pivot table.

Re: custom row colors in pivot table

ashfaq_haseeb — Tue, 30 Sep 2014 08:52:37 GMT

Yes possible

Go to Setting --> user preference --> Design Tab --> Select Always show Design menu items.

Then right click on cell you want to highlight and select Custom format cell. --> apply your required formatting here.

Hope it helps.

Regards

ASHFAQ

Re: custom row colors in pivot table

Anonymous — Tue, 30 Sep 2014 08:57:42 GMT

Hi,

You can also write condition in background color option of your chart's dimension and expression.

Thanks

Re: custom row colors in pivot table

Tue, 30 Sep 2014 09:00:49 GMT

thank you for your reply, could you please tell me what type of expression has to be use

Re: custom row colors in pivot table

Anonymous — Tue, 30 Sep 2014 09:11:26 GMT

For example,

If you have county wise sales and target and you want background color to be red for those countries who didn't meet target than you may use below condition in both dimension and expression background.

If(Sales<Target, Red())

Re: custom row colors in pivot table

jyothish8807 — Tue, 30 Sep 2014 09:22:59 GMT

Go to Settings --> User Preferences --> Design and enable the option "Always Show Design menu Items"

Then right click on the totals row --> Custom Format Cell and change color, border, font etc.

Regards