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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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