topic Re: Customized Background Color- Total Row in QlikView

Customized Background Color- Total Row

Anonymous — Sat, 12 Oct 2013 18:43:37 GMT

I need to make the background color of the Total row of a Straight Chart as Yellow. It should be done completely i.e. Dimensions as well as Expressions. Right now I can only do the Expressions portion through Visual Cues.

Is it supported currently?

Thank you.

Re: Customized Background Color- Total Row

giakoum — Sat, 12 Oct 2013 20:09:57 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.

Check out the attached example

Re: Customized Background Color- Total Row

Anonymous — Sun, 13 Oct 2013 18:47:35 GMT

Thank you, very helpful.

One thing to add, it works great with Straight Charts but Pivot Tables are little hard for this option.

Re: Customized Background Color- Total Row

giakoum — Sun, 13 Oct 2013 21:24:12 GMT

Yes, true, but this is the easiest way to go. Otherwise you need to fake the total rows, which I strongly do not recommend. Please close this discussion, if you are satisfied.