Gradient Colors in Stacked Bar chart change on reload
I have a stacked bar chart showing survey question responses on a rating scale (from agree to disagree) and i'm trying to color each secondary dimension (survey response) so that the colors fade from one response into the next. I had this set up and looking great, then i reloaded the document and QlikView shifted all the colors around. Why doesn't it use the colors in order on the Colors tab of the Properties box?? I thought about defining the colors explicitly in the expressions, but i don't know how to make them gradient that way. Can anyone help me either:
a) keep colors from shifting when i reload?
b) explicitly define gradient colors in the expression?
not sure why the colors would shift...but when you say shift, is it a specific order?
but for option b, you can use the following expression:
color(1) gives you the first color in the colors tab. similarly color(2) will give you the second color and so on. you can also use a specific color such as red(), etc. or even use rgb(). the first number in argb function represents transparency...so you can gradually make it transparent to create a gradient effect...so something like:
and so on....
of course, you can determine the steps based on number of gradient steps you need.
Thanks jsaradhi and Mario De Stefano, both of your suggestions get me a LOT closer than i've been before. But they only let me control the first color in the gradient, the second (the color it fades into) is still whichever one from the colors tab QlikView decides to throw in. Can you tell me how to define the 2nd shade as well?
Maybe i need to clarify what i'm trying to do... on the rating scale, when i show the survey responses that were '5', i want that to show in green, then the responses that were '4' the green fades into teal, then 3 fades into a darker blue and so on until the responses of 1 show as purple.