topic copy full table is not working properly in QlikView https://community.qlik.com/t5/QlikView/copy-full-table-is-not-working-properly/m-p/323635#M1187627 <HTML><HEAD></HEAD><BODY><P>Hi please help me to resolve the below issue.</P><P></P><P>input file :</P><TABLE bgcolor="#ffffff" border="1" cellpadding="0" cellspacing="0" style="font-size: 9pt;"><TBODY><TR align="left" bgcolor="#f5f5f5"><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Type Of Circuit<STRONG> </STRONG></STRONG></SPAN></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Month<STRONG> </STRONG></STRONG></SPAN></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Avg % Uptym<STRONG> </STRONG></STRONG></SPAN></TH></TR><TR align="right" bgcolor="#ffffff"><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Aug 2011</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">99.713</SPAN> </TD></TR><TR align="right" bgcolor="#ffffff"><TD align="left" bgcolor="#ffffff"><SPAN style="color: #363636;">VPN-NATIONAL</SPAN> </TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Sep 2011</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">99.95</SPAN> </TD></TR><TR align="right" bgcolor="#ffffff"><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Jul 2011</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">99.987</SPAN> </TD></TR><TR align="right" bgcolor="#ffffff"><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Aug 2011</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">99.997</SPAN> </TD></TR><TR align="right" bgcolor="#ffffff"><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Jul 2011</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">100</SPAN> </TD></TR><TR align="right" bgcolor="#ffffff"><TD align="left" bgcolor="#ffffff"><SPAN style="color: #363636;">MANAGEDSERVICES</SPAN> </TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Aug 2011</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">100</SPAN> </TD></TR><TR align="right" bgcolor="#ffffff"><TD align="left" bgcolor="#ffffff"><SPAN style="color: #363636;">INSTACC Hosted</SPAN> </TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Sep 2011</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">100</SPAN> </TD></TR><TR align="right" bgcolor="#ffffff"><TD align="left" bgcolor="#ffffff"><SPAN style="color: #363636;">NPLC</SPAN> </TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Sep 2011</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">100</SPAN></TD></TR></TBODY></TABLE><P></P><P>after formula pivot result is as below:</P><P></P><P>dimention (Type od circuit,month)</P><P>Expression sum(Avg % Uptime)</P><P></P><TABLE bgcolor="#ffffff" border="1" cellpadding="0" cellspacing="0" style="font-size: 9pt;"><TBODY><TR align="right" bgcolor="#ffffff"><TH align="left" bgcolor="#f5f5f5" nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Type Of Circuit<STRONG> </STRONG></STRONG></SPAN></TH><TH align="left" bgcolor="#f5f5f5" nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Month<STRONG> </STRONG></STRONG></SPAN></TH><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Jul 2011</SPAN> </TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Aug 2011</SPAN> </TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Sep 2011</SPAN> </TD></TR><TR align="left" bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">INSTACC Hosted</SPAN> </TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-</SPAN> </TD><TD align="right" bgcolor="#ffffff"><SPAN style="color: #363636;">100</SPAN> </TD></TR><TR align="left" bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">MANAGEDSERVICES</SPAN> </TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-</SPAN> </TD><TD align="right" bgcolor="#ffffff"><SPAN style="color: #363636;">100</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-</SPAN> </TD></TR><TR align="left" bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">NPLC</SPAN> </TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-</SPAN> </TD><TD align="right" bgcolor="#ffffff"><SPAN style="color: #363636;">100</SPAN> </TD></TR><TR align="left" bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">VPN-NATIONAL</SPAN> </TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-</SPAN> </TD><TD align="right" bgcolor="#ffffff"><SPAN style="color: #363636;">99.95</SPAN> </TD></TR><TR align="left" bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-</SPAN> </TD><TD bgcolor="#ffffff"></TD><TD align="right" bgcolor="#ffffff"><SPAN style="color: #363636;">299.987</SPAN> </TD><TD align="right" bgcolor="#ffffff"><SPAN style="color: #363636;">199.71</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-</SPAN></TD></TR></TBODY></TABLE><P></P><P>again i want to replace null value with 100 which i did using presentation tab.</P><P></P><TABLE bgcolor="#ffffff" border="1" cellpadding="0" cellspacing="0" style="font-size: 9pt;"><TBODY><TR align="right" bgcolor="#ffffff"><TH align="left" bgcolor="#f5f5f5" nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Type Of Circuit<STRONG> </STRONG></STRONG></SPAN></TH><TH align="left" bgcolor="#f5f5f5" nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Month<STRONG> </STRONG></STRONG></SPAN></TH><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Jul 2011</SPAN> </TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Aug 2011</SPAN> </TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Sep 2011</SPAN> </TD></TR><TR align="left" bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">INSTACC Hosted</SPAN> </TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">100.00</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">100.00</SPAN> </TD><TD align="right" bgcolor="#ffffff"><SPAN style="color: #363636;">100</SPAN> </TD></TR><TR align="left" bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">MANAGEDSERVICES</SPAN> </TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">100.00</SPAN> </TD><TD align="right" bgcolor="#ffffff"><SPAN style="color: #363636;">100</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">100.00</SPAN> </TD></TR><TR align="left" bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">NPLC</SPAN> </TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">100.00</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">100.00</SPAN> </TD><TD align="right" bgcolor="#ffffff"><SPAN style="color: #363636;">100</SPAN> </TD></TR><TR align="left" bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">VPN-NATIONAL</SPAN> </TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">100.00</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">100.00</SPAN> </TD><TD align="right" bgcolor="#ffffff"><SPAN style="color: #363636;">99.95</SPAN> </TD></TR><TR align="left" bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">100.00</SPAN> </TD><TD bgcolor="#ffffff"></TD><TD align="right" bgcolor="#ffffff"><SPAN style="color: #363636;">299.987</SPAN> </TD><TD align="right" bgcolor="#ffffff"><SPAN style="color: #363636;">199.71</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">100.00</SPAN></TD></TR></TBODY></TABLE><P></P><P>now i want the last result in bar chart. but i am unable to set blank as 100 in bar chart.</P><P>Please help. attaching sample qvw for reference</P></BODY></HTML> Mon, 10 Oct 2011 07:30:33 GMT pkkushwaha 2011-10-10T07:30:33Z copy full table is not working properly https://community.qlik.com/t5/QlikView/copy-full-table-is-not-working-properly/m-p/323635#M1187627 <HTML><HEAD></HEAD><BODY><P>Hi please help me to resolve the below issue.</P><P></P><P>input file :</P><TABLE bgcolor="#ffffff" border="1" cellpadding="0" cellspacing="0" style="font-size: 9pt;"><TBODY><TR align="left" bgcolor="#f5f5f5"><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Type Of Circuit<STRONG> </STRONG></STRONG></SPAN></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Month<STRONG> </STRONG></STRONG></SPAN></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Avg % Uptym<STRONG> </STRONG></STRONG></SPAN></TH></TR><TR align="right" bgcolor="#ffffff"><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Aug 2011</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">99.713</SPAN> </TD></TR><TR align="right" bgcolor="#ffffff"><TD align="left" bgcolor="#ffffff"><SPAN style="color: #363636;">VPN-NATIONAL</SPAN> </TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Sep 2011</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">99.95</SPAN> </TD></TR><TR align="right" bgcolor="#ffffff"><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Jul 2011</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">99.987</SPAN> </TD></TR><TR align="right" bgcolor="#ffffff"><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Aug 2011</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">99.997</SPAN> </TD></TR><TR align="right" bgcolor="#ffffff"><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Jul 2011</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">100</SPAN> </TD></TR><TR align="right" bgcolor="#ffffff"><TD align="left" bgcolor="#ffffff"><SPAN style="color: #363636;">MANAGEDSERVICES</SPAN> </TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Aug 2011</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">100</SPAN> </TD></TR><TR align="right" bgcolor="#ffffff"><TD align="left" bgcolor="#ffffff"><SPAN style="color: #363636;">INSTACC Hosted</SPAN> </TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Sep 2011</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">100</SPAN> </TD></TR><TR align="right" bgcolor="#ffffff"><TD align="left" bgcolor="#ffffff"><SPAN style="color: #363636;">NPLC</SPAN> </TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Sep 2011</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">100</SPAN></TD></TR></TBODY></TABLE><P></P><P>after formula pivot result is as below:</P><P></P><P>dimention (Type od circuit,month)</P><P>Expression sum(Avg % Uptime)</P><P></P><TABLE bgcolor="#ffffff" border="1" cellpadding="0" cellspacing="0" style="font-size: 9pt;"><TBODY><TR align="right" bgcolor="#ffffff"><TH align="left" bgcolor="#f5f5f5" nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Type Of Circuit<STRONG> </STRONG></STRONG></SPAN></TH><TH align="left" bgcolor="#f5f5f5" nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Month<STRONG> </STRONG></STRONG></SPAN></TH><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Jul 2011</SPAN> </TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Aug 2011</SPAN> </TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Sep 2011</SPAN> </TD></TR><TR align="left" bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">INSTACC Hosted</SPAN> </TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-</SPAN> </TD><TD align="right" bgcolor="#ffffff"><SPAN style="color: #363636;">100</SPAN> </TD></TR><TR align="left" bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">MANAGEDSERVICES</SPAN> </TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-</SPAN> </TD><TD align="right" bgcolor="#ffffff"><SPAN style="color: #363636;">100</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-</SPAN> </TD></TR><TR align="left" bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">NPLC</SPAN> </TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-</SPAN> </TD><TD align="right" bgcolor="#ffffff"><SPAN style="color: #363636;">100</SPAN> </TD></TR><TR align="left" bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">VPN-NATIONAL</SPAN> </TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-</SPAN> </TD><TD align="right" bgcolor="#ffffff"><SPAN style="color: #363636;">99.95</SPAN> </TD></TR><TR align="left" bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-</SPAN> </TD><TD bgcolor="#ffffff"></TD><TD align="right" bgcolor="#ffffff"><SPAN style="color: #363636;">299.987</SPAN> </TD><TD align="right" bgcolor="#ffffff"><SPAN style="color: #363636;">199.71</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-</SPAN></TD></TR></TBODY></TABLE><P></P><P>again i want to replace null value with 100 which i did using presentation tab.</P><P></P><TABLE bgcolor="#ffffff" border="1" cellpadding="0" cellspacing="0" style="font-size: 9pt;"><TBODY><TR align="right" bgcolor="#ffffff"><TH align="left" bgcolor="#f5f5f5" nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Type Of Circuit<STRONG> </STRONG></STRONG></SPAN></TH><TH align="left" bgcolor="#f5f5f5" nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Month<STRONG> </STRONG></STRONG></SPAN></TH><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Jul 2011</SPAN> </TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Aug 2011</SPAN> </TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Sep 2011</SPAN> </TD></TR><TR align="left" bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">INSTACC Hosted</SPAN> </TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">100.00</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">100.00</SPAN> </TD><TD align="right" bgcolor="#ffffff"><SPAN style="color: #363636;">100</SPAN> </TD></TR><TR align="left" bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">MANAGEDSERVICES</SPAN> </TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">100.00</SPAN> </TD><TD align="right" bgcolor="#ffffff"><SPAN style="color: #363636;">100</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">100.00</SPAN> </TD></TR><TR align="left" bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">NPLC</SPAN> </TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">100.00</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">100.00</SPAN> </TD><TD align="right" bgcolor="#ffffff"><SPAN style="color: #363636;">100</SPAN> </TD></TR><TR align="left" bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">VPN-NATIONAL</SPAN> </TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">100.00</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">100.00</SPAN> </TD><TD align="right" bgcolor="#ffffff"><SPAN style="color: #363636;">99.95</SPAN> </TD></TR><TR align="left" bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">100.00</SPAN> </TD><TD bgcolor="#ffffff"></TD><TD align="right" bgcolor="#ffffff"><SPAN style="color: #363636;">299.987</SPAN> </TD><TD align="right" bgcolor="#ffffff"><SPAN style="color: #363636;">199.71</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">100.00</SPAN></TD></TR></TBODY></TABLE><P></P><P>now i want the last result in bar chart. but i am unable to set blank as 100 in bar chart.</P><P>Please help. attaching sample qvw for reference</P></BODY></HTML> Mon, 10 Oct 2011 07:30:33 GMT https://community.qlik.com/t5/QlikView/copy-full-table-is-not-working-properly/m-p/323635#M1187627 pkkushwaha 2011-10-10T07:30:33Z