topic Re: Expression for different colours in Bubble chart in QlikView

Expression for different colours in Bubble chart

Thu, 27 Jun 2013 11:58:14 GMT

Hi All I am trying to write an expression for colours in a Bubble Chart. The expression works for one colour but how do I add an else if to add the other colours.

(count ([Asset ID]=0),LightBlue())
elseif(count ([Serial #]

>=5),Lightred())

Re: Expression for different colours in Bubble chart

Thu, 27 Jun 2013 11:58:43 GMT

Sorry expression is

(count ([Asset ID]=0),LightBlue())
elseif(count ([Asset ID]

>=5),Lightred())

Re: Expression for different colours in Bubble chart

Thu, 27 Jun 2013 12:17:13 GMT

if (count ([Serial #])=0, white(), if (count ([Serial #])<=100, red(), if (count ([Serial #])>101, Blue())))

Sorted