Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

New to Qliksense

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

1 Solution

Accepted Solutions
Employee
Employee

Re: New to Qliksense

Hi Loki - like this?

Mike T

Regards,
Mike Tarallo
Qlik
5 Replies
Employee
Employee

Re: New to Qliksense

Hi Loki - like this?

Mike T

Regards,
Mike Tarallo
Qlik
Not applicable

Re: New to Qliksense

Mike,

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

Re: New to Qliksense

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

Employee
Employee

Re: New to Qliksense

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

Regards,
Mike Tarallo
Qlik
Employee
Employee

Re: New to Qliksense

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

Regards,
Mike Tarallo
Qlik
Community Browser