Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
bharani8
Contributor III

Pivot : Sub Total Color change

Hi Experts - quick question...

I have a pivot and i need the sub total for each expression to be in different color shade.. May i know how to get that ?

Attached qvw for reference..

Pivot.PNG

1 Solution

Accepted Solutions
pradosh_thakur
Honored Contributor II

Re: Pivot : Sub Total Color change

Hi

is this what you need ?

Capture.PNG

regards

Pradosh

Learning never stops.
20 Replies
devarasu07
Honored Contributor II

Re: Pivot : Sub Total Color change

Hi,

Go to Settings --> User Preferences --> Design and enable the option "Always Show Design menu Items" or short cut (Ctrl+G) to enable grid mode and try to apply custom format cell color

Then right click on the totals row --> Custom Format Cell and change color, border, font etc.

P.S: tried and it's shows all in one color (Total/Sub Total).

Capture.JPG

Re: Pivot : Sub Total Color change

Use Custom cell Formatting for this.

Re: Pivot : Sub Total Color change

Three Different Colors ??

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
bharani8
Contributor III

Re: Pivot : Sub Total Color change

I need it for the full row... not one particular Cell..

bharani8
Contributor III

Re: Pivot : Sub Total Color change

Yes...I need it for the full row... not one particular Cell..

bharani8
Contributor III

Re: Pivot : Sub Total Color change

I need it for the full row... not one particular Cell..

bharani8
Contributor III

Re: Pivot : Sub Total Color change

Is this possible ??

Re: Pivot : Sub Total Color change

Don't think so..

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
laxmanqlik
Contributor II

Re: Pivot : Sub Total Color change

Hi Bharani,

Try This .. in Measure Expression, hope it will hep you

=if(Even(RowNo(TOTAL)), rgb(219,219,219), rgb(255,255,255))

ColorMix1( rank(total column(1))/noofrows(TOTAL) , rgb(15,97,119), rgb(36,242,197))