topic Re: Grid Chart colors orientation in QlikView

Grid Chart colors orientation

bgerchikov — Thu, 08 Nov 2012 20:26:36 GMT

Hello,

Here is the question:

In a grid chart, can we have colors setup by vertical, not
horizontally as on the picture attached?

Thanks!

Re: Grid Chart colors orientation

MayilVahanan — Thu, 08 Nov 2012 20:36:24 GMT

PFA

Are you looking like this?

You can set the background color based on the dimension in the expression tab by clicking '+'

Hope it helps

Re: Grid Chart colors orientation

bgerchikov — Thu, 08 Nov 2012 20:40:48 GMT

Yes,

Something like this, but if we would have 10 or more values on X axis? I'd like to avoid IF statement.

Thanks!

Re: Grid Chart colors orientation

Thu, 08 Nov 2012 21:27:20 GMT

In the example of Mayil change background color with COLOR(Year).

If your dimension isn't numeric, in the script , create for each value of the dimension a dual representation (look at dual), then use the same synthax Color( yourDimension)

Re: Grid Chart colors orientation

bgerchikov — Thu, 08 Nov 2012 21:35:26 GMT

Thanks!

I have this solution already (Rank(ColorSort,red(),blue(),green()) , but it works if you have limited number of values. What if instead of 2001,2002 and 2003 I'd, have range of 1990-2012? I will need to specify 33 colors in IF or Rank statements for each ear?

Re: Grid Chart colors orientation

MayilVahanan — Thu, 08 Nov 2012 21:40:00 GMT

Try like this

Load * Inline

[

R,G,B,Year

101,100,121,2000

210,220,200, 2001

30,230,200,2002

40,40,100, 2003

150,50,200, 2004

160,160,100, 2005

100,200,200,2006

];

Then used in the

=RGB(R,G,B) in background color for '+' expression tab.

Hope it helps

Re: Grid Chart colors orientation

bgerchikov — Thu, 08 Nov 2012 21:45:18 GMT

This makes sense. I wish there was solution in Style settings, but it looks like we don't have anything better.

Thanks!

Re: Grid Chart colors orientation

MayilVahanan — Thu, 08 Nov 2012 22:03:27 GMT

From point of view, this is best solution to solve your problem. It avoid complex if condition. And easy solution.. There is no such option in style as per my knowledge.