topic Color Fill for Totals in QlikView

Color Fill for Totals

Tue, 28 Apr 2009 03:03:15 GMT

I have 7 fields in my chart properties that I am displaying on the screen. I have sorted the results based on two of the fields in my selection. I would like to color fill the entire line at the bottom of the chart. Does anyone have any idea how to background fill the entire totals line, not just one total in the line?

Color Fill for Totals

Anonymous — Tue, 28 Apr 2009 03:13:59 GMT

Try the next:

1. Turn on design grid (it's under View menu)
2. Right-click on any cell in total line and select Custom Format Cell
3. Seelct or create a color you want.
4. Chose "appluy change to all dimensions

Regards,
Michael

Color Fill for Totals

Tue, 28 Apr 2009 03:15:48 GMT

That helps a little. I figure out how to get subtotals one color, but cannot get the grand total a different color. Any ideas?

Color Fill for Totals

Anonymous — Tue, 28 Apr 2009 03:24:11 GMT

Try using color attribute expression, and condition based on dimesionality() funcion. It returns 0 for total in pivot tables.

Reagrds,
michael

Color Fill for Totals

Tue, 29 Sep 2009 17:53:54 GMT

Dear Michael,

Thank you for the tip, my problem is that with dimensionality/color attribute I know how to alter the TEXT COLOR, but NOT the background color.

Is it possible to program the background color?! I would like to have for the different levels of sbtotals different background colors 😉

Thx in advance.

BR,

Kalin

Color Fill for Totals

Tue, 29 Sep 2009 18:09:06 GMT

Sorry, I've just found the full color attributes for background as well ;-(

I would like to be able to SAVE as THEME or something the settings I make, because the SUBTOTALS formatting of only one table would consume about 30 minutes at least. Is it possible to export formatting settings and save them somehow??@?

Thx

Kalin

Color Fill for Totals

Anonymous — Wed, 30 Sep 2009 01:41:37 GMT

Good to find that the answer follows the quesion right away...

There is no theme for this sort of customization, as far as I know. You can copy an object from one QV file to another, the chances are that the custom features will be copied as well, if the data supports it.