I have a combo chart, with bars showing one measure and a line showing another measure.
I would like to colour the bars and line with different and specific Rgb values by using an expression.Can I use an IF statement - can anyone help?
Yes you can. Here is basic expression with an IF :
if ( 1>0 , red() , green() )
You'll need to change the 1>0 to something that fits your needs.
Can you specify is it qliksense or qlikview?
if qliksense then go to appearance-> General->color -> custom-> By Expression-> if(expression>0,Green(),Red())
Same with qlikview . Use the condition
Retrieving data ...