Skip to main content
Announcements
Get Ready. A New Qlik Learning Experience is Coming February 17! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
ninnartx
Creator
Creator

Fix color of stacked bar

Hi folks,

I'm trying to fix the color of my stacked bar chart but the problem is that I have 2 date fields (Actual Doc Date, and Contract Signed Date).

I'm graphing it by Contract Signed Date and have Actual Doc Date as a list box. You'll see that the color is fixed when no year is selected from the "Actual Doc Date" field. The colors change when I select a year from the "Actual Doc Date" field.

Is there a way to fix this? I've attached a sample file.

Thanks a lot !

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Use as background color attribute expression

=pick( match(Only({<DocDate=>}Type), 'A','B', 'C','D', 'E'), rgb(70,178,157),rgb(240,202,77),rgb(227,123,64),rgb(222,91,73),rgb(200,200,200))

View solution in original post

2 Replies
swuehl
MVP
MVP

Use as background color attribute expression

=pick( match(Only({<DocDate=>}Type), 'A','B', 'C','D', 'E'), rgb(70,178,157),rgb(240,202,77),rgb(227,123,64),rgb(222,91,73),rgb(200,200,200))

ninnartx
Creator
Creator
Author

you're a genius swuehl! thank you!!