I am very new to Qlikview so am still getting use to the set analysis side of the tool.
I am trying to change the colour of a text object. As far as i can see the script seems to be ok. Here it is
IF(v.Option.Period ='YTD',
IF ( $(Max.Turnover) <25 and $(Max.Turnover) >= 0,Green(),
IF ( $(Max.Turnover) >=25 and $(Max.Turnover) < 50,Blue(),
IF ( $(Max.Turnover) >=50 and $(Max.Turnover) <= 150, Yellow(),
IF ( $(Max.Turnover) >150 and $(Max.Turnover) <= 200,Red()
)))))
The value of max turnover is '127.8%'. I am not sure if having the '%' is why it is not functioning correctly.
I also noticed that if I change the first IF option from Green to Blue then the text appears in Blue. So it seems like it is only responding to the first option in the nested IF's. I thank anyone in advance if they can assist me in this. many thanks.
