Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Aspiring_Developer
Specialist
Specialist

To add a column in a table only for color Qliksense

Hi All,

I have below scenario:-

Aspiring_Developer_0-1627902758344.png

My requirement is to add a new column like above 'Traffic light ' on the basis of below condition:-

=Pick(Match(activity_color, 'error', 'none', 'success','warning'), rgb(255, 0, 0),rgb(255, 255, 255),rgb(51, 204, 51),rgb(255, 153, 0))

This new column should only show colors on the basis of the value inside the field 'activity_color'.

How can i achieve this inside a table in qliksense ? 

 

Thanks in advance

1 Reply
Lisa_P
Employee
Employee

Try making the font color the same as the background color