Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

john_s_w_wood
Contributor

Colour coding a Block Chart

Hi

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?!

1 Reply
john_s_w_wood
Contributor

Re: Colour coding a Block Chart

Example of colour effect trying to achieve

Community Browser