https://community.qlik.com/t5/QlikView/Visual-Cue-evaluation-on-straight-table/m-p/143388#M22637 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I am trying to add a visual cue into an expression column in a straight table. The calculation is based on the value of one included dimension, and it works OK if exactly one value of that dimension is selected. If I use the same formula as an expression column, the values are calculated correctly for all rows no matter what is selected. More explicitly, my example expression is like this:</P><P style="font-style: italic; padding-left: 60px">pick( mixmatch( Level, 'Level1', 'Level2', 'Level3'), 50, 60, 80)</P><P>Is there some misconception here (anyway, I am fairly new to QV)?</P><P></P></BODY></HTML> Tue, 05 May 2009 22:41:01 GMT 2009-05-05T22:41:01Z https://community.qlik.com/t5/QlikView/Visual-Cue-evaluation-on-straight-table/m-p/143388#M22637 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I am trying to add a visual cue into an expression column in a straight table. The calculation is based on the value of one included dimension, and it works OK if exactly one value of that dimension is selected. If I use the same formula as an expression column, the values are calculated correctly for all rows no matter what is selected. More explicitly, my example expression is like this:</P><P style="font-style: italic; padding-left: 60px">pick( mixmatch( Level, 'Level1', 'Level2', 'Level3'), 50, 60, 80)</P><P>Is there some misconception here (anyway, I am fairly new to QV)?</P><P></P></BODY></HTML> Tue, 05 May 2009 22:41:01 GMT https://community.qlik.com/t5/QlikView/Visual-Cue-evaluation-on-straight-table/m-p/143388#M22637 2009-05-05T22:41:01Z https://community.qlik.com/t5/QlikView/Visual-Cue-evaluation-on-straight-table/m-p/143389#M22638 <HTML><HEAD></HEAD><BODY><P>Can you upload an example qvw to help us understand your question correctly?</P><P>-Rob</P></BODY></HTML> Tue, 05 May 2009 23:31:59 GMT https://community.qlik.com/t5/QlikView/Visual-Cue-evaluation-on-straight-table/m-p/143389#M22638 rwunderlich 2009-05-05T23:31:59Z https://community.qlik.com/t5/QlikView/Visual-Cue-evaluation-on-straight-table/m-p/143390#M22639 <HTML><HEAD></HEAD><BODY><P>Hi Rob, before sending the model I realized that the coloring was defined in the wrong place. Taking (slightly adjusted) expression to the Text Color under Expressions did the trick.</P></BODY></HTML> Wed, 06 May 2009 16:56:44 GMT https://community.qlik.com/t5/QlikView/Visual-Cue-evaluation-on-straight-table/m-p/143390#M22639 2009-05-06T16:56:44Z