Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Shubham_Deshmukh
Specialist
Specialist

How to give background color to cell along with Values?(Not through Visual cues)

For ABC row,% C condition ( if +ve,red())

For XYZ row,% C condition (If - ve , red())

Means,I have different conditions for each row.

And I want to color the cell along with % C value,but I am getting one out of them only.

Pls help.

1 Solution

Accepted Solutions
Shubham_Deshmukh
Specialist
Specialist
Author

I Got the answer.

Write the normal condition in expression & write compare and color codes condition in background color tab.So, it will give you background color and value as well.

View solution in original post

6 Replies
PrashantSangle

right click on cell> format cell > apply color.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
prat1507
Specialist
Specialist

You can use something like this

pick(match(Dim,'ABC','XYZ'),

if(% C condition>0,rgb(),rgb()),

if(% C condition>0,rgb(),rgb()))


You can specify rgb codes as per your wish.


Regards

Pratyush

Shubham_Deshmukh
Specialist
Specialist
Author

Hi Pratyush,

I already tried it , it's not working

Shubham_Deshmukh
Specialist
Specialist
Author

I Got the answer.

Write the normal condition in expression & write compare and color codes condition in background color tab.So, it will give you background color and value as well.

prat1507
Specialist
Specialist

Yes, the expression I gave you has to be written in the background color of the expression.

Nice, you got that done.


Regards
Pratyush

Shubham_Deshmukh
Specialist
Specialist
Author

Ohhhh,previousely, I didnt get it 🙂

Thanks.