topic Re: Changing the background color based on value? in QlikView https://community.qlik.com/t5/QlikView/Changing-the-background-color-based-on-value/m-p/1032356#M939619 <HTML><HEAD></HEAD><BODY><P>Check this one I have done for your two values you can do that for all conditions, refer the screenshot too.</P></BODY></HTML> Tue, 02 Feb 2016 18:54:05 GMT ajayrai 2016-02-02T18:54:05Z Changing the background color based on value? https://community.qlik.com/t5/QlikView/Changing-the-background-color-based-on-value/m-p/1032354#M939617 <HTML><HEAD></HEAD><BODY><P>Good morning!</P><P></P><P>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.</P><P></P><P>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?</P><P></P><P>Thanks in advance for any help!</P><P></P><P>Preston</P></BODY></HTML> Tue, 02 Feb 2016 13:53:31 GMT https://community.qlik.com/t5/QlikView/Changing-the-background-color-based-on-value/m-p/1032354#M939617 2016-02-02T13:53:31Z Re: Changing the background color based on value? https://community.qlik.com/t5/QlikView/Changing-the-background-color-based-on-value/m-p/1032355#M939618 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Tue, 02 Feb 2016 18:35:03 GMT https://community.qlik.com/t5/QlikView/Changing-the-background-color-based-on-value/m-p/1032355#M939618 Gysbert_Wassenaar 2016-02-02T18:35:03Z Re: Changing the background color based on value? https://community.qlik.com/t5/QlikView/Changing-the-background-color-based-on-value/m-p/1032356#M939619 <HTML><HEAD></HEAD><BODY><P>Check this one I have done for your two values you can do that for all conditions, refer the screenshot too.</P></BODY></HTML> Tue, 02 Feb 2016 18:54:05 GMT https://community.qlik.com/t5/QlikView/Changing-the-background-color-based-on-value/m-p/1032356#M939619 ajayrai 2016-02-02T18:54:05Z Re: Changing the background color based on value? https://community.qlik.com/t5/QlikView/Changing-the-background-color-based-on-value/m-p/1032357#M939620 <HTML><HEAD></HEAD><BODY><P>something like this?</P></BODY></HTML> Tue, 02 Feb 2016 19:18:33 GMT https://community.qlik.com/t5/QlikView/Changing-the-background-color-based-on-value/m-p/1032357#M939620 2016-02-02T19:18:33Z Re: Changing the background color based on value? https://community.qlik.com/t5/QlikView/Changing-the-background-color-based-on-value/m-p/1032358#M939621 <HTML><HEAD></HEAD><BODY><P>Thanks Rodrigo! Awesome example of the nested if statement that I was having trouble with.</P></BODY></HTML> Wed, 03 Feb 2016 00:30:09 GMT https://community.qlik.com/t5/QlikView/Changing-the-background-color-based-on-value/m-p/1032358#M939621 2016-02-03T00:30:09Z Re: Changing the background color based on value? https://community.qlik.com/t5/QlikView/Changing-the-background-color-based-on-value/m-p/1032359#M939622 <HTML><HEAD></HEAD><BODY><P>Glad to have helped <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 03 Feb 2016 19:45:54 GMT https://community.qlik.com/t5/QlikView/Changing-the-background-color-based-on-value/m-p/1032359#M939622 2016-02-03T19:45:54Z