topic Re: color a specific row in pivot table in QlikView

color a specific row in pivot table

sonikajain — Mon, 07 May 2012 14:22:00 GMT

Dear all,

Please advise on coloring a specifc row named 'ALL' in a pivot table.

Sonika

jagan — Mon, 07 May 2012 15:04:03 GMT

Hi,

Check attached file for solution, hope it helps you.

Check Dimension and Expression Background color expression on expanding + icon.

Regards,

Jagan.

john_duffy — Mon, 07 May 2012 17:51:44 GMT

Hello.

I've used the background colour settings as mentioned above with the dimensionality function to colour specific rows.

In the attached example, I have changed the background to light red for all detail rows assoiciated with Dept IT - dimensionality() = 3.

I have also changed the background for sub totals at the Comp level to light green - dimensionality() = 1.

Hope this helps.

John.

john_duffy — Thu, 24 May 2012 19:28:23 GMT

Hi Sonika.

Did these solutions resolve your issue?

John.

sonikajain — Mon, 28 May 2012 12:44:39 GMT

not yet