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.
