Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
haneeshmarella
Creator II
Creator II

How do I color a dimension consisting two fields with same expression?

Hi, I have a dimension based on the formula

IF(len(trim([CONTAINER]))=0,'OFF-LINE','ON-LINE') as OFF_ON_LINE

The expression for the above dimension is count(distinct case#).

How can I color the cells in straight table such a way that for OFFLINE below 70 is red and above 70 is green, and for ONLINE below 110 is red and above 110 is green?

10 Replies