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: 
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