topic Re: data presentation in QlikView https://community.qlik.com/t5/QlikView/data-presentation/m-p/405040#M568703 <HTML><HEAD></HEAD><BODY><P>Can anyone please help me how to resolve the above issue.It is very urgent to complete</P><P></P><P>Thanks</P></BODY></HTML> Tue, 06 Nov 2012 09:57:55 GMT ssriramin19 2012-11-06T09:57:55Z data presentation https://community.qlik.com/t5/QlikView/data-presentation/m-p/405039#M568702 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>&nbsp;&nbsp; My requirement is that I need to show only the non zero numbers in dpa lag 0,dpa lag 1 and dpa lag 2 columns .Below is the table from teh table</P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 535px;"><TBODY><TR><TD class="xl64" height="20" width="64">Apr 2012</TD><TD class="xl64" style="border-left: medium none;" width="64">Dec 2011</TD><TD align="right" class="xl65" style="border-left: medium none;" width="105">0.00</TD><TD align="right" class="xl65" style="border-left: medium none;" width="110">358169182.00</TD><TD align="right" class="xl66" style="border-left: medium none;" width="64">0%</TD><TD align="right" class="xl66" style="border-left: medium none;" width="64">0%</TD><TD class="xl66" style="border-left: medium none;" width="64">-</TD></TR><TR><TD class="xl64" height="20" style="border-top: medium none;">Apr 2012</TD><TD class="xl64" style="border-top: medium none; border-left: medium none;">Jan 2012</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">0.00</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">434485823.00</TD><TD align="right" class="xl66" style="border-top: medium none; border-left: medium none;">0%</TD><TD align="right" class="xl66" style="border-top: medium none; border-left: medium none;">0%</TD><TD align="right" class="xl66" style="border-top: medium none; border-left: medium none;">0%</TD></TR><TR><TD class="xl64" height="20" style="border-top: medium none;">Apr 2012</TD><TD class="xl64" style="border-top: medium none; border-left: medium none;">Feb 2012</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">0.00</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">732762856.00</TD><TD align="right" class="xl66" style="border-top: medium none; border-left: medium none;">0%</TD><TD align="right" class="xl66" style="border-top: medium none; border-left: medium none;">0%</TD><TD align="right" class="xl66" style="border-top: medium none; border-left: medium none;">0%</TD></TR><TR><TD class="xl64" height="20" style="border-top: medium none;">Apr 2012</TD><TD class="xl64" style="border-top: medium none; border-left: medium none;">Mar 2012</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">0.00</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">1286501586.00</TD><TD align="right" class="xl66" style="border-top: medium none; border-left: medium none;">0%</TD><TD align="right" class="xl66" style="border-top: medium none; border-left: medium none;">0%</TD><TD align="right" class="xl66" style="border-top: medium none; border-left: medium none;">0%</TD></TR><TR><TD class="xl64" height="20" style="border-top: medium none;">Apr 2012</TD><TD class="xl64" style="border-top: medium none; border-left: medium none;">Apr 2012</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">0.00</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">241257800.00</TD><TD align="right" class="xl66" style="border-top: medium none; border-left: medium none;">0%</TD><TD align="right" class="xl66" style="border-top: medium none; border-left: medium none;">0%</TD><TD align="right" class="xl66" style="border-top: medium none; border-left: medium none;">0%</TD></TR><TR><TD class="xl64" height="20" style="border-top: medium none;"><STRONG>Apr 2012</STRONG></TD><TD class="xl64" style="border-top: medium none; border-left: medium none;"><STRONG>May 2012</STRONG></TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;"><STRONG>176753106.00</STRONG></TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;"><STRONG>72396926.00</STRONG></TD><TD align="right" class="xl66" style="border-top: medium none; border-left: medium none;"><STRONG>73%</STRONG></TD><TD align="right" class="xl66" style="border-top: medium none; border-left: medium none;"><STRONG>14%</STRONG></TD><TD align="right" class="xl66" style="border-top: medium none; border-left: medium none;"><STRONG>24%</STRONG></TD></TR><TR><TD class="xl64" height="20" style="border-top: medium none;">Apr 2012</TD><TD class="xl64" style="border-top: medium none; border-left: medium none;">Jun 2012</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">214755.00</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">66785522.00</TD><TD align="right" class="xl66" style="border-top: medium none; border-left: medium none;">0%</TD><TD align="right" class="xl66" style="border-top: medium none; border-left: medium none;">0%</TD><TD align="right" class="xl66" style="border-top: medium none; border-left: medium none;">0%</TD></TR><TR><TD class="xl64" height="20" style="border-top: medium none;">Apr 2012</TD><TD class="xl64" style="border-top: medium none; border-left: medium none;">Jul 2012</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">17234.00</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">10892301.00</TD><TD align="right" class="xl66" style="border-top: medium none; border-left: medium none;">0%</TD><TD align="right" class="xl66" style="border-top: medium none; border-left: medium none;">0%</TD><TD align="right" class="xl66" style="border-top: medium none; border-left: medium none;">0%</TD></TR><TR><TD class="xl64" height="20" style="border-top: medium none;">Apr 2012</TD><TD class="xl64" style="border-top: medium none; border-left: medium none;">Aug 2012</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">380.00</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">10892339.00</TD><TD align="right" class="xl66" style="border-top: medium none; border-left: medium none;">0%</TD><TD align="right" class="xl66" style="border-top: medium none; border-left: medium none;">0%</TD><TD align="right" class="xl66" style="border-top: medium none; border-left: medium none;">0%</TD></TR><TR><TD class="xl64" height="20" style="border-top: medium none;">Apr 2012</TD><TD class="xl64" style="border-top: medium none; border-left: medium none;">Sep 2012</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">2.00</TD><TD align="right" class="xl65" style="border-top: medium none; border-left: medium none;">0.00</TD><TD align="right" class="xl66" style="border-top: medium none; border-left: medium none;">0%</TD><TD align="right" class="xl66" style="border-top: medium none; border-left: medium none;">0%</TD><TD align="right" class="xl66" style="border-top: medium none; border-left: medium none;">0%</TD></TR></TBODY></TABLE><P></P><P>Only the&nbsp; values highlighted must be dised in the table.</P><P></P><P></P><P></P><P>Can anyone help me to resolve the above problem?</P><P></P><P>Thanks</P></BODY></HTML> Tue, 06 Nov 2012 08:15:30 GMT https://community.qlik.com/t5/QlikView/data-presentation/m-p/405039#M568702 ssriramin19 2012-11-06T08:15:30Z Re: data presentation https://community.qlik.com/t5/QlikView/data-presentation/m-p/405040#M568703 <HTML><HEAD></HEAD><BODY><P>Can anyone please help me how to resolve the above issue.It is very urgent to complete</P><P></P><P>Thanks</P></BODY></HTML> Tue, 06 Nov 2012 09:57:55 GMT https://community.qlik.com/t5/QlikView/data-presentation/m-p/405040#M568703 ssriramin19 2012-11-06T09:57:55Z Re: data presentation https://community.qlik.com/t5/QlikView/data-presentation/m-p/405041#M568704 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can you attach the sample file.</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Tue, 06 Nov 2012 11:12:20 GMT https://community.qlik.com/t5/QlikView/data-presentation/m-p/405041#M568704 jagan 2012-11-06T11:12:20Z Re: data presentation https://community.qlik.com/t5/QlikView/data-presentation/m-p/405042#M568705 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>PFA file for solution.</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Tue, 06 Nov 2012 11:16:18 GMT https://community.qlik.com/t5/QlikView/data-presentation/m-p/405042#M568705 jagan 2012-11-06T11:16:18Z