topic Re: Pivot : Sub Total Color change in QlikView

Pivot : Sub Total Color change

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

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..

Re: Pivot : Sub Total Color change

devarasu07 — Thu, 12 Oct 2017 06:13:13 GMT

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).

Re: Pivot : Sub Total Color change

its_anandrjs — Thu, 12 Oct 2017 06:13:35 GMT

Use Custom cell Formatting for this.

Re: Pivot : Sub Total Color change

Anil_Babu_Samineni — Thu, 12 Oct 2017 06:20:13 GMT

Three Different Colors ??

Re: Pivot : Sub Total Color change

bharani8 — Thu, 12 Oct 2017 06:20:52 GMT

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

Re: Pivot : Sub Total Color change

bharani8 — Thu, 12 Oct 2017 06:21:07 GMT

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

Re: Pivot : Sub Total Color change

bharani8 — Thu, 12 Oct 2017 06:21:22 GMT

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

Re: Pivot : Sub Total Color change

bharani8 — Thu, 12 Oct 2017 06:40:55 GMT

Is this possible ??

Re: Pivot : Sub Total Color change

Anil_Babu_Samineni — Thu, 12 Oct 2017 06:42:47 GMT

Don't think so..

Re: Pivot : Sub Total Color change

laxmanqlik — Thu, 12 Oct 2017 06:49:25 GMT

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))

Re: Pivot : Sub Total Color change

devarasu07 — Thu, 12 Oct 2017 06:51:15 GMT

Hi,

The Custom format color you can apply entire total /sub total row (refer to previous screen shot /attachment) for sample.

Note: total/sub total - multi color background only not working in grid mode

Re: Pivot : Sub Total Color change

laxmanqlik — Thu, 12 Oct 2017 06:54:24 GMT

Sorry not in Measure expression

Go to Appearance-> colours-> and select BY EXPRESSION and use the expression

Re: Pivot : Sub Total Color change

pradosh_thakur — Thu, 12 Oct 2017 07:37:15 GMT

is this what you need ?

regards

Pradosh

Re: Pivot : Sub Total Color change

Anil_Babu_Samineni — Thu, 12 Oct 2017 07:44:08 GMT

Good one, Are you done this using Dimensionality() for whole dimensions and measures..??

Re: Pivot : Sub Total Color change

pradosh_thakur — Thu, 12 Oct 2017 07:47:12 GMT

yes Anil. I have used dimensionality() for this.

regards

Pradosh

Re: Pivot : Sub Total Color change

Anil_Babu_Samineni — Thu, 12 Oct 2017 07:50:15 GMT

What if we have more than 12 / 20 dims and expressions. do we need to set up same for all. Looking from cleveranjos‌ to get into work in simple manner. And rek is make sense

Again , Good job Pradosh

Re: Pivot : Sub Total Color change

bharani8 — Thu, 12 Oct 2017 08:11:28 GMT

Yes Pradosh... This is what i was looking for... How and where i need to tweek to get this?

Re: Pivot : Sub Total Color change

bharani8 — Thu, 12 Oct 2017 08:15:20 GMT

i got it!! Thanks for your Help!!

Re: Pivot : Sub Total Color change

bharani8 — Thu, 12 Oct 2017 09:17:59 GMT

Hi - One more issue i am facing.. If my initial value is Null or No value... i dont see the color for that.. How to overcome that ?

Re: Pivot : Sub Total Color change

pradosh_thakur — Thu, 12 Oct 2017 09:20:44 GMT

presentation -> uncheck supress zero value ??

if it works for your requirement

regards

Pradosh