Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikview979
Specialist
Specialist

Background color

Hi Experts,

PFA

i want to change background color in pivot table  which i marked in single  row

Untitled.png

18 Replies
Anil_Babu_Samineni

I have not seen Any Attachment, Would you attach the qvw file

or, You have to enter for all metrics of BG Color expression like below

If(ProductCode = '30-Day RFs', Green(), Red())

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
qlikview979
Specialist
Specialist
Author

Hi anil,

can you check in above screen shot

i want to change expression back ground color also,it mean "30-Day RFs"  back ground color i need to show in blue color.

Rgards

mahesh

Anil_Babu_Samineni

Again Confused to me, Would you share sample to look the same?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
qlikview979
Specialist
Specialist
Author

Simple ,i want to change  Expression back ground  color

Ex:-

sum(sales)

100

200

300

here i want to change back ground color for sum(sales)

Anil_Babu_Samineni

True that is how my first reply works. Or just use for Sum(Sales) color as Blue() like below. Expand the expression and then Give Blue() for BG Color in Definition. It should work

Capture.PNG

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
qlikview979
Specialist
Specialist
Author

not like that,

i want to change Lable back ground color in expression tab

Anil_Babu_Samineni

Like this?

Capture.PNG

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
vishsaggi
Champion III
Champion III

Why dont you use Customer Format Cell using Ctrl+G and select a label right click Custom Format and change background color.

qlikview979
Specialist
Specialist
Author

Exactly,but here when i drag the expressions its not working