Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Changing the background color based on value?

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

1 Solution

Accepted Solutions
Not applicable

Re: Changing the background color based on value?

something like this?

View solution in original post

5 Replies
MVP & Luminary
MVP & Luminary

Re: Changing the background color based on value?

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.


talk is cheap, supply exceeds demand
Partner
Partner

Re: Changing the background color based on value?

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

Not applicable

Re: Changing the background color based on value?

something like this?

View solution in original post

Not applicable

Re: Changing the background color based on value?

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

Not applicable

Re: Changing the background color based on value?

Glad to have helped