topic Re: colours in x-axis in QlikView

colours in x-axis

Fri, 22 Apr 2016 13:18:39 GMT

Hi All.

is it possible to get different colours for the values of x-axis? I'd want the label 2016 in red, 2015 in blue..

thanks in advance

luca

Re: colours in x-axis

agni_gold — Fri, 22 Apr 2016 13:40:09 GMT

I think , it is not possible for dimension ,

But you can make same color for whole dimension. like below.

Re: colours in x-axis

Gysbert_Wassenaar — Sun, 24 Apr 2016 09:42:36 GMT

You can use a combi chart and add a second expression: =dual(Year, 0). Set the display option of that expression to Text on Axis only. You can then change the background color of the text by clicking on the + in front of the expression and enter an expression that calculates the color: pick(match(Year,'2016','2015','2014','2013'),red(),blue(),black(),green()). Replace Year with the name of your year dimension. See below for a similar example

Re: colours in x-axis

agni_gold — Sun, 24 Apr 2016 10:33:45 GMT

In this case we need to do hard coding for that

Re: colours in x-axis

Tue, 26 Apr 2016 08:41:34 GMT

Agnivesh, Gysbert, many thanks for your reply.

Gysbert, your solution works!

Is it possible to vertically align the text (England, Greater London..)?

luca

Re: colours in x-axis

Gysbert_Wassenaar — Tue, 26 Apr 2016 08:48:07 GMT

Vertically align? Do you mean rotate the text 90 degrees? That's not possible. But perhaps you can change the orientation of the chart to horizontal bars. You can do that on the Style tab of the properties window.

Re: colours in x-axis

Tue, 26 Apr 2016 08:59:47 GMT

thanks..