Hvine
Contributor
2020-07-02
08:27 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:
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.
441 Views
0 Replies