Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I'm after a bit of help making a radar graph have coloured zones, so almost like the triangle shape on my chart attached is over an archery board if you like.
I'm after the plot area to be coloured as follows:
0% to 79%: RGB 255,0,0
79% to 85%: RGB 255,128,0
85% to 100%: RGB 0,127,0.
Many thanks for your help,
Gareth
Go to Colors >> inside colors >> Calculated >> write a expression
if(sum(Score)>= 0 and sum(Score) <= 79 ,rgb(255,0,0),
if(sum(Score)>79 and sum(Score) <= 85 ,rgb(255,128,0),
if(sum(Score)> 85 and sum(Score) <= 100 ,rgb(0,127,0) )))
Hi,
Try liek this in your volor expression
if( sum(Score)<.79,RGB(255,0,0),
if(sum(Score)>=.79 and sum(Score)<.85 ,RGB(255,128,0),RGB(0,127,0)))
That doesn't work for what I need.
I need something like the attached but I don't know how to achieve this in QlikView.
Thanks,
Gareth
Hi,
I am more after something like the attached, but I don't know how to achieve it in QlikView.
Many thanks,
Gareth