topic Help required for Conditional Text Coloring in QlikView https://community.qlik.com/t5/QlikView/Help-required-for-Conditional-Text-Coloring/m-p/433856#M161724 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have data like following table:</P><TABLE border="0" cellpadding="0" cellspacing="0" width="212"><TBODY><TR><TD class="xl64" height="20" width="84">Employee</TD><TD class="xl64" style="border-left: none;" width="64">Class</TD><TD class="xl64" style="border-left: none;" width="64">Flag</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">A</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">111</TD><TD class="xl63" style="border-top: none; border-left: none;">N</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">A</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">121</TD><TD class="xl63" style="border-top: none; border-left: none;">Y</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">A</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">131</TD><TD class="xl63" style="border-top: none; border-left: none;">N</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">B</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">211</TD><TD class="xl63" style="border-top: none; border-left: none;">Y</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">B</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">212</TD><TD class="xl63" style="border-top: none; border-left: none;">N</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">C</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">311</TD><TD class="xl63" style="border-top: none; border-left: none;">N</TD></TR></TBODY></TABLE><P></P><P>But i want single row for every employee. So I have used <STRONG>Concat </STRONG>and I have table like below:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="244"><TBODY><TR><TD class="xl66" height="20" width="81">Employee</TD><TD class="xl66" style="border-left: none;" width="99">Class</TD><TD class="xl66" style="border-left: none;" width="64">Flag</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">A</TD><TD class="xl65" style="border-top: none; border-left: none;">111/121/131</TD><TD class="xl65" style="border-top: none; border-left: none;">N/Y/N</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">B</TD><TD class="xl65" style="border-top: none; border-left: none;">211/212</TD><TD class="xl65" style="border-top: none; border-left: none;">Y/N</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">C</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">311</TD><TD class="xl65" style="border-top: none; border-left: none;">N</TD></TR></TBODY></TABLE><P></P><P>But I want to display class with flag 'Y' in red color, rest of with black.</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="margin-left: 4.65pt;" width="244"><TBODY><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="81"><P style="margin-bottom: 0.0001pt;"><SPAN style="color: black;"><STRONG>Employee</STRONG></SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P style="margin-bottom: 0.0001pt;"><SPAN style="color: black;"><STRONG>Class</STRONG></SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P style="margin-bottom: 0.0001pt;"><SPAN style="color: black;"><STRONG>Flag</STRONG></SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="81"><P style="margin-bottom: 0.0001pt;"><SPAN style="color: black;">A</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P style="margin-bottom: 0.0001pt;"><SPAN style="color: black;">111/</SPAN><SPAN style="color: red;">121</SPAN><SPAN style="color: black;">/131</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P style="margin-bottom: 0.0001pt;"><SPAN style="color: black;">N/Y/N</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="81"><P style="margin-bottom: 0.0001pt;"><SPAN style="color: black;">B</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P style="margin-bottom: 0.0001pt;"><SPAN style="color: red;">211</SPAN><SPAN style="color: black;">/212</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P style="margin-bottom: 0.0001pt;"><SPAN style="color: black;">Y/N</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="81"><P style="margin-bottom: 0.0001pt;"><SPAN style="color: black;">C</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="margin-bottom: 0.0001pt; text-align: right;"><SPAN style="color: black;">311</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P style="margin-bottom: 0.0001pt;"><SPAN style="color: black;">N</SPAN></P></TD></TR></TBODY></TABLE><P></P><P></P><P>How to achieve this?</P><P></P><P></P><P></P><P>Thanx in Advance..!!</P></BODY></HTML> Tue, 09 Apr 2013 00:05:32 GMT 2013-04-09T00:05:32Z Help required for Conditional Text Coloring https://community.qlik.com/t5/QlikView/Help-required-for-Conditional-Text-Coloring/m-p/433856#M161724 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have data like following table:</P><TABLE border="0" cellpadding="0" cellspacing="0" width="212"><TBODY><TR><TD class="xl64" height="20" width="84">Employee</TD><TD class="xl64" style="border-left: none;" width="64">Class</TD><TD class="xl64" style="border-left: none;" width="64">Flag</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">A</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">111</TD><TD class="xl63" style="border-top: none; border-left: none;">N</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">A</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">121</TD><TD class="xl63" style="border-top: none; border-left: none;">Y</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">A</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">131</TD><TD class="xl63" style="border-top: none; border-left: none;">N</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">B</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">211</TD><TD class="xl63" style="border-top: none; border-left: none;">Y</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">B</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">212</TD><TD class="xl63" style="border-top: none; border-left: none;">N</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">C</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">311</TD><TD class="xl63" style="border-top: none; border-left: none;">N</TD></TR></TBODY></TABLE><P></P><P>But i want single row for every employee. So I have used <STRONG>Concat </STRONG>and I have table like below:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="244"><TBODY><TR><TD class="xl66" height="20" width="81">Employee</TD><TD class="xl66" style="border-left: none;" width="99">Class</TD><TD class="xl66" style="border-left: none;" width="64">Flag</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">A</TD><TD class="xl65" style="border-top: none; border-left: none;">111/121/131</TD><TD class="xl65" style="border-top: none; border-left: none;">N/Y/N</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">B</TD><TD class="xl65" style="border-top: none; border-left: none;">211/212</TD><TD class="xl65" style="border-top: none; border-left: none;">Y/N</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">C</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">311</TD><TD class="xl65" style="border-top: none; border-left: none;">N</TD></TR></TBODY></TABLE><P></P><P>But I want to display class with flag 'Y' in red color, rest of with black.</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="margin-left: 4.65pt;" width="244"><TBODY><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="81"><P style="margin-bottom: 0.0001pt;"><SPAN style="color: black;"><STRONG>Employee</STRONG></SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P style="margin-bottom: 0.0001pt;"><SPAN style="color: black;"><STRONG>Class</STRONG></SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P style="margin-bottom: 0.0001pt;"><SPAN style="color: black;"><STRONG>Flag</STRONG></SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="81"><P style="margin-bottom: 0.0001pt;"><SPAN style="color: black;">A</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P style="margin-bottom: 0.0001pt;"><SPAN style="color: black;">111/</SPAN><SPAN style="color: red;">121</SPAN><SPAN style="color: black;">/131</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P style="margin-bottom: 0.0001pt;"><SPAN style="color: black;">N/Y/N</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="81"><P style="margin-bottom: 0.0001pt;"><SPAN style="color: black;">B</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P style="margin-bottom: 0.0001pt;"><SPAN style="color: red;">211</SPAN><SPAN style="color: black;">/212</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P style="margin-bottom: 0.0001pt;"><SPAN style="color: black;">Y/N</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="81"><P style="margin-bottom: 0.0001pt;"><SPAN style="color: black;">C</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="margin-bottom: 0.0001pt; text-align: right;"><SPAN style="color: black;">311</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P style="margin-bottom: 0.0001pt;"><SPAN style="color: black;">N</SPAN></P></TD></TR></TBODY></TABLE><P></P><P></P><P>How to achieve this?</P><P></P><P></P><P></P><P>Thanx in Advance..!!</P></BODY></HTML> Tue, 09 Apr 2013 00:05:32 GMT https://community.qlik.com/t5/QlikView/Help-required-for-Conditional-Text-Coloring/m-p/433856#M161724 2013-04-09T00:05:32Z