Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Hvine
Contributor
Contributor

Qlik sense How to assign color code using expression when your Expression is a valuelist

Hello All,

I had to create the table below using the valuelist:

Hvine_0-1593692322538.png

Dimension:

=Valuelist('artist spaces','area','collect','spaces')

Expression 1: Extremely Important:

=If(Valuelist('artist spaces','area','collect','spaces')='artist spaces',Count({<[artist spaces]={'Extremely Important'}>}[artist spaces])/ Count(Total [artist spaces])....etc......

Expression 2: Important:

=If(Valuelist('artist spaces','area','collect','spaces')='artist spaces',Count({<[artist spaces]={'Important'}>}[artist spaces])/ Count(Total [artist spaces])....etc......

Now, when I look at the color, it is very awful.

Does someone has the formula to change the color?

Thank you for your help.

 

Labels (2)
0 Replies