Fill Color as per Choice in group bar chart

[sunil-kumar5]

Hi Community,

I want to change the color of my Group or Stacked bar chart as per my choice however I am not able to do so.

Qlik sense has their own fix color based on Measure, Dimension or Single color. There is one more option that is expression will it help me to change the color? Anyone please advise how to change it. How I can put the expression to change my measures color. I have a dimension simply as months, measures are Ticket_Status as "Closed" and "Pending".

Thanks

[tommyl · Accepted solution]

Hello,

You can pick color "by Expression" and write this to the expression field:

if(Ticket_Status)={'Closed'}, RGB(0,100,255), RGB(255,0,125))

if you have more than two status, please write a nested if. 

For RGB's please refer this link if you dont have. 

I hope this is what you need. 

Cheers,

T. 

[sunil-kumar5]

Thanks for the assistance

[tommyl]

You are welcome👍

Regards,

Tommy,