Changing the background color based on value?

[#1]

Good morning!

I'm a new user of Qlikview trying to find out how to get the background of a cell of information to change based off of a predefined number range. Before I begin, I have enclosed the files I'm trying to work with.

What I would like help with is if I make my dimension Top Level Criteria, how would I get the expressions, such as possibly Alt1 through 11 to display the background colors based on the Color Coding Rules ranges for each color?

Thanks in advance for any help!

Preston

[Gysbert_Wassenaar]

I don't understand the coding rules, but perhaps this blog post can explain to you how to implement a color table and/or how to use expressions to assign colors to cells.

[ajayrai]

Check this one I have done for your two values you can do that for all conditions, refer the screenshot too.

[#4 · Accepted solution]

something like this?

[#5]

Thanks Rodrigo! Awesome example of the nested if statement that I was having trouble with.

[#6]

Glad to have helped