Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
amar2016
Contributor II
Contributor II

Pivot cell text color

SourceTeamBDate2017-12-282018-01-042018-01-11TotalYearly Target
Client1Team1 5101010151030306000
Client1Team2 260110160530200
Client2Team1 510010100151003030040450
Client2Team2 6001100160033003000

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.

6 Replies
andrey_krylov
Specialist
Specialist

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

ChennaiahNallani
Creator III
Creator III

use visual cues in properties. see below

Capture.PNG

Anil_Babu_Samineni

This can be, will you able to share sample?

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)
amar2016
Contributor II
Contributor II
Author

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" ?

manoj217
Creator III
Creator III

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

amar2016
Contributor II
Contributor II
Author

Thanks fro your reply.

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