Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi,
Thank you for this, I still receive an error with this. Decile is a number. Still the ')' expected error
thank you, this worked.
Awesome, I am glad I was able to help