Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Choosing colors for each measure on a combo chart.

Hello to all,

I am kind of new to Qlik (I've been reading the tutorials and such) and I'm stuck while trying to do a Combo Chart with some dummy data.

The chart on the attachment is good but not exactly as I want.

I want that chart to be a different color from JAN to AUG which are the months that are already closed. Now I'm able to this with this:

IF(todaysmonth >= month, Red(),Green())

on the "color by expression" field, but then I want the color the rest of the months with the colors I pick, per measure.

Is there any way of doing this?

The only way I saw of doing this involved 2 dimensions, using something like this on the color expression:

if(ValueList('Sales','Quota','Expenses')='Sales'

  ,rgb(0,192,0)

  ,if(ValueList('Sales','Quota','Expenses')='Quota'

     ,rgb(0,0,192)

     ,rgb(192,0,0)

     )

  )

but I can only have 1 dimension on a combo chart.

Thanks in advance.

Community Browser