New to Qliksense

[#1]

Can we color individual cells of a table based on certain conditions?

If yes, how do we achieve that.

I understand that we can do conditional formatting / coloring. BUT that seems to apply for entire column. However in my case I need different colors for diff cells within same column based on certain condition.

For ex, if value < = 50, then red, > 50 and <=75, then yellow, > 75 then green.

-Loki

[Michael_Tarallo · Accepted solution]

Hi Loki - like this?

Mike T

[#3]

Mike,

Yes, exactly like that. Can you share code please.

[robert_mika]

You can use Text Color Expression and use formula to color your text.

You can use this format

IF(VALUE>50,RED(), IF....

or use RGB() function

[Michael_Tarallo]

If you are looking for something similar to this:

Check out color by expression - available here:

http://help.qlik.com/sense/2.1/en-US/online/#../Subsystems/Hub/Content/Colors/color-by-expression.ht...

here is a sample .qvf attached:

if(SUM(Sales) >= 50000, green(),

if(Sum(Sales)<=49000 AND SUM(Sales) >=10000, yellow(), red()))

Please copy .qvf file to your C:\Users\<user profile>\Documents\Qlik\Sense\Apps and refresh Qlik Sense Desktop with F5

Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

Regards,

Mike Tarallo

Qlik

[Michael_Tarallo]

Loki, great to hear - I have branched a new discussion thread for your other question.

For this discussion, please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

Regards,

Mike Tarallo

Qlik