topic Re: Pivot cell text color in QlikView

Pivot cell text color

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

Source	Team	BDate	2017-12-28	2018-01-04	2018-01-11	Total	Yearly Target
Client1	Team1		510	1010	1510	3030	6000
Client1	Team2		260	110	160	530	200
Client2	Team1		5100	10100	15100	30300	40450
Client2	Team2		600	1100	1600	3300	3000

I have the above Pivot data.

Can we have the color textcolor as Red of number of "2017-12-28" if the number is greater than the number of "2018-01-11" else text color should be green.

Also, can we have the textcolor as Yellow of "Total" if the number is greater than "Yearly Target" else text color should be Blue.

Re: Pivot cell text color

andrey_krylov — Sun, 26 Aug 2018 18:25:36 GMT

Hi Amar. Yes, you can customize the textcolor (Background Color, Text Format, etc.) of your pivot cells. Open Chart properties -> Expressions or Dimensions

To assign a color use RGB() function or predefined Red(), Blue(), Green() etc. As for "Total" it can be

If([Total] > [Yearly Target], Yellow(), Blue()). In this example [Total] and [Yearly Target] are column names and can be replaced by expressions

If(Sum(Total) > Sum([Yearly Target]), Yellow(), Blue())

Re: Pivot cell text color

ChennaiahNallani — Mon, 27 Aug 2018 05:36:28 GMT

use visual cues in properties. see below

Re: Pivot cell text color

Anil_Babu_Samineni — Mon, 27 Aug 2018 07:06:58 GMT

This can be, will you able to share sample?

Re: Pivot cell text color

Anonymous — Mon, 27 Aug 2018 11:00:42 GMT

This can be done.

I want to get for the below conditions:

Can we have the color textcolor as Red of number of "2017-12-28" if the number is greater than the number of "2018-01-11" else text color should be green.

Also, can we have the textcolor as Yellow of "Total" if the number is greater than "Yearly Target" else text color should be Blue.

How to get the values of cell "2017-12-28" to be compared with the values of "2018-01-11" ?

Re: Pivot cell text color

manoj217 — Mon, 27 Aug 2018 11:07:50 GMT

by using visual cues you can change the background color, font, font style just you can write the expression in upper, lower boxes. these will reflect into the data

Re: Pivot cell text color

Anonymous — Mon, 27 Aug 2018 15:47:26 GMT

Thanks fro your reply.

How to get the values of cell "2017-12-28" to be compared with the values of "2018-01-11" ?