Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Change text or background color in a table

Hey guys,

From the table below, I am trying to achieve the following:

I  want  the first highest amount in the Amount column to change to a specific color both the background and the text to say red per customer selection that will be made. But, I don't know how to get that done. Please any help will be truly appreciated.

 

YearMonthInvoice-typeAmount# of invoices
2015JanAdvances€ 5001
2015FebAdvances€ 5001
2015MarAdvances€ 5001
2015AprAdvances€ 5001
2015MayAdvances€ 5001
2015JunAdvances 6501
2015JulAdvances€ 6501
2015AugAdvances€ 6501
2015SepAdvances€ 6501
2015OctAdvances€ 4501
2015NovAdvances€ 4501
2015DecAdvances€ 4501

Thanks in advance,

Simon.

4 Replies
Clever_Anjos
Employee
Employee

Go to "Visual Cues" tab, there you can configure rules to change color using a formula like

MAX( TOTAL Aggr(sum(Amount), Year, Month)))

Not applicable
Author

Hey Clever,

Thanks for your reply but I have the amount as a dimension so based on the table I showed, can you help me with the expression I can use to change the colors. I am completely new to this.

Thanks

Anonymous
Not applicable
Author

On the Dimension tab you should see a small plus sign to the left of each Used Dimension.  Click the plus sign, click Text Color and add an expression, maybe something like :

     if ( Month = 'Jun' , Red() , Green() )

Then change the expression to what suits your needs.

Clever_Anjos
Employee
Employee

PFA