topic Coloured Grid Chart modifying Luminosity parameter in HSL in QlikView

Coloured Grid Chart modifying Luminosity parameter in HSL

ebrambilla — Tue, 08 Jul 2014 14:38:35 GMT

Hello,

I want to build a Grid Chart showing which Product groups were sold, over a range of 3 years.

Please consider the example in the attachment. What I need is a chart like the following:

BUT the colors of circles will be set using the function HSL (hue, saturation, luminosity) keeping fixed hue and saturation parameters, and modifying the Luminosity parameter. this will result in a "light" circle for small values, "dark" circles for higher values.

As the luminosity should be set up using a linear function, I found the needed one:

y=(170*x+600-230*MAX)/(10-MAX) where x represent the Sum(OrderValue) and MAX the biggest element in the grid chart.

x is the sum(OrderValue), MAX is the maximum value between all sum(OrderValue) and y is the luminosity to be calculated,.

So, for Sum(ORDERVALUE)=10 we will have a luminosity=230, for the MAX we will have a luminosity=60 (darkest).

My problem is how to calculate the MAX parameter in this equation (because of my poor knowledge of aggregation functions!).

How to setup the calculus?

Many Thanks!

I understand in a grid chart using a "scale color" on the circles is the only way to give an idea about the circle values. In fact, a grid chart with variable-sized circles is not convenient when values differ too much. Little values generate invisible circles in this case; I do not know other ways to change size of circles in a grid chart i.e using a formula. Is that right? Thanks for any indications

Re: Coloured Grid Chart modifying Luminosity parameter in HSL

rwunderlich — Tue, 08 Jul 2014 22:13:26 GMT

MAX would be defined as:

max(TOTAL aggr(Sum(ORDERVALUE),ORDERYEAR,PGROUP))

Thanks for including a sample qvw. Makes it much easier to answer your question.

-Rob

http://masterssummit.com

http://robwunderlich.com

Re: Re: Coloured Grid Chart modifying Luminosity parameter in HSL

ebrambilla — Wed, 09 Jul 2014 09:15:47 GMT

Thank you Rob for you precious help! I have to study better aggr()...!

Here the qvd resulting, with two variations and a modification respect to my original thinking: I used rgb() instead of hsl()

Re: Coloured Grid Chart modifying Luminosity parameter in HSL

rwunderlich — Wed, 09 Jul 2014 18:27:53 GMT

Looks nice, Another approach I use is agrb() with a single color and just vary the "A" value.

-Rob