Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Valued Contributor III

Color to total

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?

grna.PNG

Tags (1)
1 Solution

Accepted Solutions
Highlighted
Valued Contributor II

Re: Color to total

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

View solution in original post

9 Replies
Highlighted
Valued Contributor II

Re: Color to total

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

View solution in original post

Highlighted
Valued Contributor III

Re: Color to total

tried not working

Highlighted
Valued Contributor III

Re: Color to total

its not taking for grand total  rest values its coluring.

Highlighted
Partner
Partner

Re: Color to total

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?

Highlighted
Partner
Partner

Re: Color to total

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

Highlighted
Valued Contributor III

Re: Color to total

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

so what can i use?

Highlighted
Partner
Partner

Re: Color to total

then just use

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

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

Highlighted
Valued Contributor III

Re: Color to total

yeah  i got it custom format cell

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

Partner
Partner

Re: Color to total

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.