Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys?
Without putting in a background colour expression can we change the colours of the chart? i know you can change the pallette but it doesn't seem to be as easy as that with multiple choices within a dimension. To illustrate this I have attached a small screenshot. Why does Qlikview colourise in this way?
Any comments would be helpful.
thanks
Yeah, using the same color multiple times doesn't work so well.
Did you check out the Colors tab of the Options? You can set each individual color using a color picker. I'm guessing your defaults are changed. You can try Get Default Colors or click advanced and you can retrieve the QlikView defaults.
My colour picker as is follows. I don't see why if 2 segments are the same colour when they aren't 2 spaces away in the colour picker. Am i missing something here?
Thanks
Yeah, that is odd. By default, you should get the colors, in order, as they appear on that Color tab. I can't tell exactly, but it seems like that repeated blue is color 3.
How many possible values do you have for those items on the chart? Is it more than 18?
I would look into your sorting. Try sorting by your expression value, so that the items will be in order based on value. Then QlikView should pick the colors in order. You could be sorting by something else and it just so happens that those two blue items are 18 apart in that sorting scheme. If you sort by expression value (desc) they should get colors 1 and 3.
EDIT: Just noticed you had persistant colors checked. Try unchecking that. From the manual: Persistent Colors -
Locks the colors assigned to each data point even if selections reduce the total number of data points. In this mode color representation will never change for a given data point, but you run the risk of having two adjacent bars or slices with the same color for different data points.
I think that has sorted it out, great spot!
Thanks.