topic Re: Straight table count values in QlikView https://community.qlik.com/t5/QlikView/Straight-table-count-values/m-p/1082505#M360628 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>Pick(Count({&lt;status={'hold'&gt;}&gt;employee) + 1, 'n', 'y')</STRONG></SPAN></P></BODY></HTML> Thu, 05 May 2016 17:36:12 GMT sunny_talwar 2016-05-05T17:36:12Z Straight table count values https://community.qlik.com/t5/QlikView/Straight-table-count-values/m-p/1082504#M360627 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I have a straight table in which i am calculating a count</P><P>My requirement is, if i have a value 1 in count it should show as 'Y'</P><P><SPAN style="font-size: 13.3333px;">My requirement is, if i have a value 0 in count it should show as 'N'</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P>&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 508px;"><TBODY><TR><TD height="20" width="64">employee</TD><TD width="64">status</TD><TD width="242">count({&lt;status=={'hold'&gt;}&gt;employee)</TD><TD class="xl65" width="138">my expexted out put</TD></TR><TR><TD height="20">aaaa</TD><TD>hold</TD><TD align="right">1</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; y</TD></TR><TR><TD height="20">bbb</TD><TD>un hold</TD><TD align="right">0</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; n</TD></TR><TR><TD height="20">ccc</TD><TD>hold</TD><TD align="right">1</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; y</TD></TR><TR><TD height="20">ddd</TD><TD>unhold</TD><TD align="right">0</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; n</TD></TR></TBODY></TABLE><P></P><P></P><P>Thank you</P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P></P><P></P><P></P></BODY></HTML> Thu, 05 May 2016 17:34:37 GMT https://community.qlik.com/t5/QlikView/Straight-table-count-values/m-p/1082504#M360627 2016-05-05T17:34:37Z Re: Straight table count values https://community.qlik.com/t5/QlikView/Straight-table-count-values/m-p/1082505#M360628 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>Pick(Count({&lt;status={'hold'&gt;}&gt;employee) + 1, 'n', 'y')</STRONG></SPAN></P></BODY></HTML> Thu, 05 May 2016 17:36:12 GMT https://community.qlik.com/t5/QlikView/Straight-table-count-values/m-p/1082505#M360628 sunny_talwar 2016-05-05T17:36:12Z Re: Straight table count values https://community.qlik.com/t5/QlikView/Straight-table-count-values/m-p/1082506#M360629 <HTML><HEAD></HEAD><BODY><P>Thank you so much Sunny</P></BODY></HTML> Fri, 06 May 2016 06:24:05 GMT https://community.qlik.com/t5/QlikView/Straight-table-count-values/m-p/1082506#M360629 2016-05-06T06:24:05Z