topic Re: Visual Cues in Pivot with different limits in QlikView https://community.qlik.com/t5/QlikView/Visual-Cues-in-Pivot-with-different-limits/m-p/1289107#M516994 <HTML><HEAD></HEAD><BODY><P>Add an expression in the advanced formatting section for the respective Expression(s)...something like this:</P><P></P><P><IMG alt="2017-03-02_13-16-50.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/155075_2017-03-02_13-16-50.png" style="height: 498px; width: 620px;" /></P></BODY></HTML> Thu, 02 Mar 2017 20:19:16 GMT jcs_2015 2017-03-02T20:19:16Z Visual Cues in Pivot with different limits https://community.qlik.com/t5/QlikView/Visual-Cues-in-Pivot-with-different-limits/m-p/1289106#M516993 <HTML><HEAD></HEAD><BODY><P>Hi1</P><P>I have a pivot table vithe 6 dimention values and 8 different expressions. See attached file</P><P></P><P>I have also loaded a list of target values. It's differet targets for each dimentions.</P><P>E.g.For one expression, Store A has a target of 99,55, store B 99,38 etc.</P><P></P><P>What i want to is to set the coulur to Red of an expression/dimention if the value is below the target value.</P><P></P><P>How can I do this?</P></BODY></HTML> Wed, 01 Mar 2017 15:16:39 GMT https://community.qlik.com/t5/QlikView/Visual-Cues-in-Pivot-with-different-limits/m-p/1289106#M516993 stekol61 2017-03-01T15:16:39Z Re: Visual Cues in Pivot with different limits https://community.qlik.com/t5/QlikView/Visual-Cues-in-Pivot-with-different-limits/m-p/1289107#M516994 <HTML><HEAD></HEAD><BODY><P>Add an expression in the advanced formatting section for the respective Expression(s)...something like this:</P><P></P><P><IMG alt="2017-03-02_13-16-50.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/155075_2017-03-02_13-16-50.png" style="height: 498px; width: 620px;" /></P></BODY></HTML> Thu, 02 Mar 2017 20:19:16 GMT https://community.qlik.com/t5/QlikView/Visual-Cues-in-Pivot-with-different-limits/m-p/1289107#M516994 jcs_2015 2017-03-02T20:19:16Z Re: Visual Cues in Pivot with different limits https://community.qlik.com/t5/QlikView/Visual-Cues-in-Pivot-with-different-limits/m-p/1289108#M516995 <HTML><HEAD></HEAD><BODY><P>As Jim suggested use the background expressions based on your Target values for each expression field.</P><P>Attached is the sample based on your excel. Changed the Field value for Field A lesser than target to get the red background. Check and let us know. Add the remaining target values as mentioned in the app.</P></BODY></HTML> Thu, 02 Mar 2017 21:17:37 GMT https://community.qlik.com/t5/QlikView/Visual-Cues-in-Pivot-with-different-limits/m-p/1289108#M516995 vishsaggi 2017-03-02T21:17:37Z