How to add colour in charts!!??

[#1]

Hello Friends!! i'm having some problem with adding colours under columns, inside a Chart table. I've added the qlikview file with some detail to what i want.

please have a look!

Thank you!! 😄

[erichshiino · Accepted solution]

Hi, Please, check my expression on the chart. Open the "+" sign on the expressions and check the syntax on background and font color.

Hope it helps!

Erich

[#3]

Hi! Thanks for that solution! i knew the colours, i just didn't know how to give the statement to add those colours inside. Thanks! 😄

[#4]

Hi, Can i just ask. From the sample you gave me,

could you give me an expression which would enable,

1) When i click SUB, colour is red.

2) When i click BP, colour is green.

3)When i click OEM, colour is lightcyan.

4)When i click PANEL, colour is lightmagenta.

5)When i click ENDUSER, Colour is yellow.

Can this be done?

[erichshiino]

Sure,

Easiest way:nested if's:

- if( FIELD='SUB', LIGHTRED(),

IF(FIELD = 'BP', lightgreen(),

if(FIELD='OEM',RGB(200,100,200) ) ) -> And so on... I just made up the last RGB .. but you can get the idea. Just dont forget to close all the ( )

A more complicated way would be to create a table on the data model with one color for each one of these field values. Then, you would not need the ifs.