Dear Qlikview user
I have built a pivot table and for one expression I have put a character CHR(9711) (Which is a circle) in as the expression
My dimensions are Month year and Metric
In the text colour of the expression, I would like to change the colour, depending on the metric and the different target. I have started to write the expression, but the expression is only ever working for the first metric I.e. Metric A and is ignoring the rest of my expression
Could someone kindly take a look and see what I am doing wrong
=If({$<TB_Question = {'Safe'}, TB_Metric = {'A'}>}TB_Value
<=2,
$(vColour_Green),
If({$<TB_Question = {'Safe'}, TB_Metric = {'A'}>}TB_Value
>2,
$(vColour_Orange),
If({$<TB_Question = {'Safe'}, TB_Metric = {'B'}>}TB_Value
=0,
$(vColour_Green),
If({$<TB_Question = {'Safe'}, TB_Metric = {'B'}>}TB_Value
>0,
$(vColour_Orange)
))))
Kind Regards
Helen
