Hi,
I'd appreciate some help with something if possible.
I'm attempting to evaluate an IF statement within Calculated condition for the background colour of a text field in Qlikview.
I have a number of ranges to colour for a RAG status as follows:
100% - 90% = Green
89% - 80% = Amber
<=79% = Red
I also have set analysis which calculates the field as follows, which evaluates correctly: ( I’ve changed the fields value for protection purposes )
num(Count ({$< SAFE = {'Yes'}, WORKS -= {'Unsafe'}>} ID )*100/Count({$< SAFE = {'Yes','No'}, WORKS -= {'Unsafe'}>} ID ),.00)
when I add in a single condition to test, it works as follows :
=IF
(num(Count ({$< SAFE = {'Yes'}, WORKS -= {'Unsafe'}>} ID )*100/Count({$< SAFE = {'Yes','No'}, WORKS -= {'Unsafe'}>} ID ),.00)<='79.00', RGB(255,128,64)
,RGB(255,79,79)
)
But when I then attempt to add the other RAG status into as additional IF’s, it doesn’t work and the final ‘)’ say’s there an error with it :
=if
(num(Count ({$< SAFE = {'Yes'}, WORKS -= {'Unsafe'}>} ID )*100/Count({$< SAFE = {'Yes','No'}, WORKS -= {'Unsafe'}>} ID ),.00)<='79.00', RGB(255,79,79),
if
(num(Count ({$< SAFE = {'Yes'}, WORKS -= {'Unsafe'}>} ID )*100/Count({$< SAFE = {'Yes','No'}, WORKS -= {'Unsafe'}>} ID ),.00)<='89.00',
and if
(num(Count ({$< SAFE = {'Yes'}, WORKS -= {'Unsafe'}>} ID )*100/Count({$< SAFE = {'Yes','No'}, WORKS -= {'Unsafe'}>} ID ),.00)>='80.00',RGB(255,128,64)
,RGB(255,79,79) )))
The ELSE Colour would therefore be anything >89 and would be Green.
I’ve tried so many different ways, and my next try is by adding the original and creating this as a Variable and adding the variable into the calculation, but wanted to make sure it worked by adding in the condition.
Thanks in advance for any help or assistance.
Barry_S
Pt 2, would be then to look at 3 individual box colours, to then calculate the overall RAG status of another box :
Eg. ( If any of the boxes are Red, then Red, If anything is Amber and not Red, then Amber, ELSE Green )
