topic Re: Help for data representation. in QlikView https://community.qlik.com/t5/QlikView/Help-for-data-representation/m-p/555975#M207568 <HTML><HEAD></HEAD><BODY><P>Hi Dhiraj,</P><P></P><P>this looks like an ideal candidate for a pivot table.</P><P></P><P>Dimensions are Task and Date, and the expression would perhaps be Only(status).</P><P></P><P>Marcus</P></BODY></HTML> Thu, 31 Oct 2013 14:27:11 GMT marcus_malinow 2013-10-31T14:27:11Z Help for data representation. https://community.qlik.com/t5/QlikView/Help-for-data-representation/m-p/555974#M207567 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am new in Qlikview Development so bare with me.</P><P></P><P>I need the help on following activity !</P><P></P><P>Input :-</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="WIDTH: 203px;"><TBODY><TR><TD class="xl65" height="20" width="64">Task</TD><TD class="xl65" style="border-left: medium none;" width="75">Date</TD><TD class="xl65" style="border-left: medium none;" width="64">status</TD></TR><TR><TD class="xl63" height="20" style="border-top: medium none;">aa</TD><TD align="right" class="xl64" style="border-left: medium none; border-top: medium none;">11/11/2011</TD><TD class="xl63" style="border-left: medium none; border-top: medium none;">Pass</TD></TR><TR><TD class="xl63" height="20" style="border-top: medium none;">bb</TD><TD align="right" class="xl64" style="border-left: medium none; border-top: medium none;">11/11/2011</TD><TD class="xl63" style="border-left: medium none; border-top: medium none;">fail</TD></TR><TR><TD class="xl63" height="20" style="border-top: medium none;">cc</TD><TD align="right" class="xl64" style="border-left: medium none; border-top: medium none;">11/11/2011</TD><TD class="xl63" style="border-left: medium none; border-top: medium none;">Pass</TD></TR><TR><TD class="xl63" height="20" style="border-top: medium none;">aa</TD><TD align="right" class="xl64" style="border-left: medium none; border-top: medium none;">11/12/2011</TD><TD class="xl63" style="border-left: medium none; border-top: medium none;">fail</TD></TR><TR><TD class="xl63" height="20" style="border-top: medium none;">bb</TD><TD align="right" class="xl64" style="border-left: medium none; border-top: medium none;">11/12/2011</TD><TD class="xl63" style="border-left: medium none; border-top: medium none;">Pass</TD></TR><TR><TD class="xl63" height="20" style="border-top: medium none;">cc</TD><TD align="right" class="xl64" style="border-left: medium none; border-top: medium none;">11/12/2011</TD><TD class="xl63" style="border-left: medium none; border-top: medium none;">fail</TD></TR></TBODY></TABLE><P></P><P>OutPut:-</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="214"><TBODY><TR><TD class="xl66" height="20" width="64">Task</TD><TD align="right" class="xl67" style="border-left: medium none;" width="75">11/11/2011</TD><TD align="right" class="xl67" style="border-left: medium none;" width="75">11/12/2011</TD></TR><TR><TD class="xl65" height="20" style="border-top: medium none;">aa</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">Pass</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">fail</TD></TR><TR><TD class="xl65" height="20" style="border-top: medium none;">bb</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">fail</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">Pass</TD></TR><TR><TD class="xl65" height="20" style="border-top: medium none;">cc</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">Pass</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">fail</TD></TR></TBODY></TABLE><P></P><P></P><P>Thanks,</P><P>D J</P></BODY></HTML> Thu, 31 Oct 2013 14:18:36 GMT https://community.qlik.com/t5/QlikView/Help-for-data-representation/m-p/555974#M207567 2013-10-31T14:18:36Z Re: Help for data representation. https://community.qlik.com/t5/QlikView/Help-for-data-representation/m-p/555975#M207568 <HTML><HEAD></HEAD><BODY><P>Hi Dhiraj,</P><P></P><P>this looks like an ideal candidate for a pivot table.</P><P></P><P>Dimensions are Task and Date, and the expression would perhaps be Only(status).</P><P></P><P>Marcus</P></BODY></HTML> Thu, 31 Oct 2013 14:27:11 GMT https://community.qlik.com/t5/QlikView/Help-for-data-representation/m-p/555975#M207568 marcus_malinow 2013-10-31T14:27:11Z Re: Help for data representation. https://community.qlik.com/t5/QlikView/Help-for-data-representation/m-p/555976#M207569 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Check thre file attached with the solution.</P><P></P><P>JV</P><P><A href="http://biexperience.wordpress.com/" title="http://biexperience.wordpress.com/">BI Experience | A place to share our Business Intelligence experiences</A></P></BODY></HTML> Thu, 31 Oct 2013 14:28:08 GMT https://community.qlik.com/t5/QlikView/Help-for-data-representation/m-p/555976#M207569 jvitantonio 2013-10-31T14:28:08Z