topic Re: Format Pivot Chart in QlikView

Format Pivot Chart

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

Has anyone experience in formatting the colour of the expression sum? See below you can see that the table is grey etc but the expression total colour has stayed white, I'm sure this is a setting somewhere but i have gone a little stare crazy.

Thanks Brett

Re: Format Pivot Chart

Kushal_Chawda — Tue, 03 May 2016 08:38:33 GMT

Do you have Background expression for cell Color? or using Visual Cues?

Re: Format Pivot Chart

sunny_talwar — Tue, 03 May 2016 08:43:58 GMT

May be try this approach to color:

Custom formatting table cells - The Qlik Fix! The Qlik Fix!

Re: Format Pivot Chart

bnelson111 — Tue, 03 May 2016 09:39:02 GMT

Background Expression

Re: Format Pivot Chart

jonathandienst — Tue, 03 May 2016 09:40:06 GMT

Well I suggest then that you show us the expression...

Re: Format Pivot Chart

Kushal_Chawda — Tue, 03 May 2016 09:42:43 GMT

what is expression?

Re: Format Pivot Chart

vikasmahajan — Tue, 03 May 2016 10:14:01 GMT

Click on expression -> select Background Color -> give set analysis -> if( col1 >col2,RGB( No,No,No))

Hope this helps you

Vikas

Re: Format Pivot Chart

pooja_sn — Tue, 03 May 2016 10:19:24 GMT

Right click on a cell that you want to format -> Custom Format Cell -> set colors you want.

Re: Format Pivot Chart

Chanty4u — Tue, 03 May 2016 10:26:40 GMT

if not custom format cell.

u can try with Dimensionality () also.

How to use - Dimensionality()