Qlikview trellis chart

[#1]

Hi All,

I have a Trellis Chat and i am wondering is is possible to change the bar colors for a category as it looks very boring? I have attached a Screenshot.

Thanks,

Kevin

[whiteline]

Expand Expression for bars.

For Background color expresion use:

=Color(FieldIndex([put your trellis dimension here]))

[#3]

I need to this this by category. Say the clinet services bar should be green, the commercial red and so on.

Any ideas?

Thanks,

Kevin

[#4]

Hi I am looking for the bars to be like this the code you supplied doesnt work.

Thanks,

Kevin

[whiteline]

=Color(FieldIndex([put your category dimension here]))

[#6]

hi I havee attahced the QVW as i cant get it working.

Thanks,

Kevin

[whiteline · Accepted solution]

Oops. I forget the syntax of FieldIndex.

Use this:

=Color(FieldIndex('IR_FUNCTION', IR_FUNCTION))