topic Re: Color to total in QlikView

Color to total

soniasweety — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

i want to give color to grand total in pivot table. [grand total text color] totals am getting bg color but grand total text colur still grey color i want that also to be yellow how to achieve this?

Re: Color to total

neelamsaroha157 — Wed, 05 Sep 2018 12:11:54 GMT

Can you try by enabling the grid layout (ctrl+G) and then right click on the total row -> 'custom format cell' ->background color....

Re: Color to total

soniasweety — Wed, 05 Sep 2018 12:14:07 GMT

tried not working

Re: Color to total

soniasweety — Wed, 05 Sep 2018 12:15:40 GMT

its not taking for grand total rest values its coluring.

Re: Color to total

Anonymous — Wed, 05 Sep 2018 12:16:46 GMT

if do define your bg_Color (for each column) to

if (Dimensionality()=0, yellow())

only the total should appear in yellow

do you Need yellow also above?

Re: Color to total

Anonymous — Wed, 05 Sep 2018 12:18:29 GMT

in my Pivot table I get complet column colored by defining bg_Color = yellow()

Re: Color to total

soniasweety — Wed, 05 Sep 2018 12:20:42 GMT

No i want grand total row only full yellow data should be colured

so what can i use?

Re: Color to total

Anonymous — Wed, 05 Sep 2018 12:23:25 GMT

then just use

if (Dimensionality()=0, yellow())

that Colors only the last row (my example I only colored first column)

Re: Color to total

soniasweety — Wed, 05 Sep 2018 12:25:26 GMT

yeah i got it custom format cell

i need to select for all dimensions and expressions. then it worked . thanks for respose

Re: Color to total

Anonymous — Wed, 05 Sep 2018 12:32:32 GMT

Hi,

as Neelam Said

enabling the grid layout (ctrl+G) and then right click on the total row -> 'custom format cell' ->background color..fins

find the attached App.

Color to total