I need to change the background color for values of a particular column. The issue is that there's no consistent rule, which can be applied at the column level, in order to change the background color for all values of that column. The formula

[#1]

Please refer to the attached xls file. This would serve as a data source for my qlikview document. In the xls, there's one column known as RAG. This column values have different background colors. You will notice that the formula used for changing the background colors for different cells is different for most of the rows, and is not consistent for all the column values.

In order to import this data into Qlikview, is there a way I can get the correct background colors for all the vaues of the RAG column?

Pls. help.

Regards,

Swati

[#2 · Accepted solution]

Hi Swati,

Instead of putting efforts in importing color from xls, you can give color in QV only.

Plz refer to the attached file.

Logic is :

If RAG = R, Red color, IF RAG = A, Orange color, IF RAG = G, Green color.

This way you need not bother about what condition was used in xls.

Go to Expression-RAG-Click on + sign near RAG Expression, Background color.

Hope its fine.

Happy Thoughts

[#3]

Hi Ravi,

Thanks so much for your response again.

It worked..:-)

Best Regards,

Swati Bansal

[#4]

Hi,

I have a similar problem but the solution provided didn't help me.

I want to give a colour to the different bars in my bar chart.

There are 3 bars maximum. every time the year is shown (2008, 2009 and 2010)

I tried the following formula in the expressions tab and then Background

If(Year='2009',green())

If(Year='2010',yellow())

If(Year='2008',blue())

When I enter only the first if statement, 2009 shows up green, but as soon as I enter more (second line/ if statement), it doesn't work anymore. Anybody any idea what I'm doing wrong?

Thanks in advance!

[nicole]

Hi,

try this:

if(Year='2008', yellow(),if(Year='2009',green(),if(Year='2010',red())))

Nicole

[#6]

Ok, that works! Great, Thank you.

I was thinking I tried all possible combinations, but I must have missed something.

How come Qlikview is not too easy to add if and or formulas compared to other programs?

Is there an overview of what sort of syntaxis it uses? I've been searching, but couldn't find anything...it would help me to avoid asking rather simple questions like the one above 🙂

Thanks again for your help!