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.
Scorecard_Apr_2010-15-07.qvw 141.0 K
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
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!
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!