Nested if for color expression

[#1]

Howdy, I am trying to make a conditional if statement for a color expression in qlik sense. It goes something like this:

if((decile = '1' or decile = '2' or decile = '3' or decile = '4'), green(),

if (decile = '5' or decile '6' or decile = '7')

,blue()

if(decile = '8' or decile = '9' or decile = '10')

,red())

but for some reason I am still getting an error on parenthesis, 'expecting a ')'. Any assistance?

[#2]

Hi,

Thank you for this, I still receive an error with this. Decile is a number. Still the ')' expected error

[#3]

thank you, this worked.

[sunny_talwar]

Awesome, I am glad I was able to help