topic Re: Colors for scatter chart in QlikView

Colors for scatter chart

karolina_ — Tue, 12 Nov 2013 11:41:35 GMT

Hi All,

I would like to color bubbles on scatter charts by metric chosen by user for example continent,country

Below there is a code to color first 10 that in put in expression -> background color:

if($(vDataName)='$(=$(vColorSelection(1)))',rgb(255,0,0),

if($(vDataName)='$(=$(vColorSelection(2)))',rgb(128,0,0),

if($(vDataName)='$(=$(vColorSelection(3)))',rgb(0,128,0),

if($(vDataName)='$(=$(vColorSelection(4)))',rgb(0,255,0),

if($(vDataName)='$(=$(vColorSelection(5)))',rgb(128,0,128),

if($(vDataName)='$(=$(vColorSelection(6)))',rgb(155,0,64),

if($(vDataName)='$(=$(vColorSelection(7)))',rgb(255,0,255),

if($(vDataName)='$(=$(vColorSelection(8)))',rgb(0,64,128),

if($(vDataName)='$(=$(vColorSelection(9)))',rgb(128,64,0),

if($(vDataName)='$(=$(vColorSelection(10)))',rgb(64,0,64)

,rgb(192,192,192))

)))))))))

where

vColorSelection -> SubField(concat(DISTINCT $(vDataName),'|'),'|',($1))

$(vDataName) -> Field Name

Some of the metrics has just 4 values some over 100. I would like to put it in the loop from 1 to GetPossibleCount($(vDataName)).

How can I do the loop in the chart? [I tried valueloop() but i had other dimension and it's not working correctly]

Thanks in advance

Re: Colors for scatter chart

Anonymous — Tue, 12 Nov 2013 21:36:58 GMT

(Not a solution, just an idea that may be helpful.)

It is easier to modify the color palette according your color list, and use color(n) function instead of rgb(). It easy to loop like this (10 colors in this example):

color(mod(RowNo(),10)+1)

There is a limit though, 18 colors in the palette.

Regards,

Michael

Re: Colors for scatter chart

karolina_ — Wed, 13 Nov 2013 07:29:41 GMT

I was thinking of putting some variable and changing within the loop (that I dont have yet).
But nice tips always welcome and it's perfect for now.
Thank you Michael