topic Fix color of stacked bar in QlikView

Fix color of stacked bar

ninnartx — Sat, 07 May 2016 14:25:43 GMT

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 !

Re: Fix color of stacked bar

swuehl — Sat, 07 May 2016 21:33:11 GMT

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

Re: Fix color of stacked bar

ninnartx — Mon, 09 May 2016 02:52:56 GMT

you're a genius swuehl! thank you!!