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: 
Applicable88
Creator III
Creator III

Change color of Value list dimension

Hello,

i thought before that its only possible to change the color of the whole column of a value list dimension. 

First I have a regular Value list dimension like this:

   If(ValueList('Daily','Workforce','8888')='Daily', count...........,  If(ValueList('Daily','Workforce','8888')='Workforce'.....count....and so on

In a straight table I don't want to change the value fields for 'Workforce' and '8888' but for 'Daily'

Adding to the regular dimension column, I can put in the field function for color in the straight table a similar value list function to adress only the dimension I want to change:

If(ValueList('Daily','Workforce','8888')='Daily' ,
rgb(192,0,0),0)

Now every value I get will be displayed in red. But I want to put another condition: Only when the value is bigger than zero. Zero values should stay white.

How to write the nested or addtional condition to make that?

Thanks in advance. 

0 Replies