topic Conditionally Color Partial Sum/Total Lines Only in QlikView

Conditionally Color Partial Sum/Total Lines Only

Tue, 02 Mar 2010 16:39:58 GMT

Is it possible to only conditionally color the partial sum or total lines? I only want to see the totals conditionally colored in a pivot table.

Conditionally Color Partial Sum/Total Lines Only

Miguel_Angel_Baeyens — Tue, 02 Mar 2010 16:47:48 GMT

Hello,

I'd use dimensionality() function for that. Once you have created and placed your fields where you want to be, use in any expression and dimension -click on the "+" sign next to the dimension or expression name to expand and go to "Text Color"- something like

If(dimensionality() = 3, RGB(23, 23, 23), RGB(255, 0, 0))

Of course, colors can change, so dimensionality (depending on how many expressions do you have and where is set the total in your char).

Conditionally Color Partial Sum/Total Lines Only

Tue, 02 Mar 2010 17:00:41 GMT

That did it. Thank you very much.