Colour coding a Block Chart

john_s_w_wood — Tue, 02 Jun 2015 14:45:46 GMT

I am looking at different ways to present a block chart and I'm experimenting with constant colours.

So I have 2 dimensions - L1 Rate Band*,

L2 Description

then an expression sum(clients)

*I am using a class and aggr function to calc rate band in other words it is dynamic and output for a row might be "£30<=Rate<£35"

=class(aggr(avg(Price),Description),50,'Rate')

I would like the L1's in the same band to be the same colour. I would like to loop round the 18 colour settings for the chart using the color(x) function.

Anyone got a slick way of doing this? Id also like to exclude having to use L1 and only L2 with the colour being the L1 but block charts do not have a sort option?!

Re: Colour coding a Block Chart

john_s_w_wood — Tue, 02 Jun 2015 14:54:48 GMT

Example of colour effect trying to achieve

topic Colour coding a Block Chart in QlikView

Colour coding a Block Chart

Re: Colour coding a Block Chart