Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
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 (3)
0 Replies