Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Loki - like this?
Mike T
Mike,
Yes, exactly like that. Can you share code please.
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
If you are looking for something similar to this:
Check out color by expression - available here:
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
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