topic the nonexistent data impact in stacked chart? in QlikView https://community.qlik.com/t5/QlikView/the-nonexistent-data-impact-in-stacked-chart/m-p/818345#M288530 <HTML><HEAD></HEAD><BODY><P>just in below data</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 317px;"><TBODY><TR style="height: 12.75pt;"><TD class="xl63" height="17" style="height: 12.75pt; width: 82pt;" width="109">ECC_DAte_BAse </TD><TD class="xl63" style="border-left: none; width: 108pt;" width="144">FAmily </TD><TD class="xl64" style="border-left: none; width: 48pt;" width="64">Sum</TD></TR><TR style="height: 12.75pt;"><TD class="xl66" height="35" rowspan="2" style="border-bottom: .5pt solid silver; height: 26.25pt; border-top: none; width: 82pt;" width="109">17.10.2014</TD><TD class="xl64" style="border-top: none; border-left: none; width: 108pt;" width="144">A</TD><TD class="xl65" style="border-top: none; border-left: none; width: 48pt;" width="64">3</TD></TR><TR style="mso-height-source: userset; height: 13.5pt;"><TD class="xl64" height="18" style="height: 13.5pt; border-top: none; border-left: none; width: 108pt;" width="144">B</TD><TD class="xl65" style="border-top: none; border-left: none; width: 48pt;" width="64">183</TD></TR><TR style="height: 12.75pt;"><TD class="xl66" height="51" rowspan="3" style="border-bottom: .5pt solid silver; height: 38.25pt; border-top: none; width: 82pt;" width="109">24.10.2014</TD><TD class="xl64" style="border-top: none; border-left: none; width: 108pt;" width="144">C</TD><TD class="xl65" style="border-top: none; border-left: none; width: 48pt;" width="64">20</TD></TR><TR style="height: 12.75pt;"><TD class="xl64" height="17" style="height: 12.75pt; border-top: none; border-left: none; width: 108pt;" width="144">A</TD><TD class="xl65" style="border-top: none; border-left: none; width: 48pt;" width="64">7</TD></TR><TR style="height: 12.75pt;"><TD class="xl64" height="17" style="height: 12.75pt; border-top: none; border-left: none; width: 108pt;" width="144">B</TD><TD class="xl65" style="border-top: none; border-left: none; width: 48pt;" width="64">193</TD></TR><TR style="height: 12.75pt;"><TD class="xl66" height="51" rowspan="3" style="border-bottom: .5pt solid silver; height: 38.25pt; border-top: none; width: 82pt;" width="109">31.10.2014</TD><TD class="xl64" style="border-top: none; border-left: none; width: 108pt;" width="144">A</TD><TD class="xl65" style="border-top: none; border-left: none; width: 48pt;" width="64">12</TD></TR><TR style="height: 12.75pt;"><TD class="xl64" height="17" style="height: 12.75pt; border-top: none; border-left: none; width: 108pt;" width="144">B</TD><TD class="xl65" style="border-top: none; border-left: none; width: 48pt;" width="64">1714</TD></TR><TR style="height: 12.75pt;"><TD class="xl64" height="17" style="height: 12.75pt; border-top: none; border-left: none; width: 108pt;" width="144">D</TD><TD class="xl65" style="border-top: none; border-left: none; width: 48pt;" width="64">158</TD></TR><TR style="height: 12.75pt;"><TD class="xl66" height="51" rowspan="3" style="border-bottom: .5pt solid silver; height: 38.25pt; border-top: none; width: 82pt;" width="109">7.11.2014</TD><TD class="xl64" style="border-top: none; border-left: none; width: 108pt;" width="144">C</TD><TD class="xl65" style="border-top: none; border-left: none; width: 48pt;" width="64">16</TD></TR><TR style="height: 12.75pt;"><TD class="xl64" height="17" style="height: 12.75pt; border-top: none; border-left: none; width: 108pt;" width="144">A</TD><TD class="xl65" style="border-top: none; border-left: none; width: 48pt;" width="64">94</TD></TR><TR style="height: 12.75pt;"><TD class="xl64" height="17" style="height: 12.75pt; border-top: none; border-left: none; width: 108pt;" width="144">B</TD><TD class="xl65" style="border-top: none; border-left: none; width: 48pt;" width="64">133</TD></TR><TR style="height: 12.75pt;"><TD class="xl66" height="51" rowspan="3" style="border-bottom: .5pt solid silver; height: 38.25pt; border-top: none; width: 82pt;" width="109">28.11.2014</TD><TD class="xl64" style="border-top: none; border-left: none; width: 108pt;" width="144">C</TD><TD class="xl65" style="border-top: none; border-left: none; width: 48pt;" width="64">85</TD></TR><TR style="height: 12.75pt;"><TD class="xl64" height="17" style="height: 12.75pt; border-top: none; border-left: none; width: 108pt;" width="144">A</TD><TD class="xl65" style="border-top: none; border-left: none; width: 48pt;" width="64">579</TD></TR><TR style="height: 12.75pt;"><TD class="xl64" height="17" style="height: 12.75pt; border-top: none; border-left: none; width: 108pt;" width="144">B</TD><TD class="xl65" style="border-top: none; border-left: none; width: 48pt;" width="64">1713</TD></TR></TBODY></TABLE><P></P><P>we can found that some family info is not in dates.</P><P>just like the 'D', not in 7.11.2014 and 28.11.2014</P><P>but look at the chart, even not data in 7.11.2014, the line still keep in it, what happen? </P><P></P><P><IMG alt="150303_111938_220_CAP.jpg" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/79698_150303_111938_220_CAP.jpg" style="height: 260px; width: 620px;" /></P><P></P><P>suppose it should like this</P><P><IMG alt="2.jpg" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/79699_2.jpg" style="height: 260px; width: 620px;" /></P><P></P><P></P><P>anyone can help ?</P><P></P><P>thanks</P></BODY></HTML> Tue, 03 Mar 2015 03:46:26 GMT guantujiang 2015-03-03T03:46:26Z the nonexistent data impact in stacked chart? https://community.qlik.com/t5/QlikView/the-nonexistent-data-impact-in-stacked-chart/m-p/818345#M288530 <HTML><HEAD></HEAD><BODY><P>just in below data</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 317px;"><TBODY><TR style="height: 12.75pt;"><TD class="xl63" height="17" style="height: 12.75pt; width: 82pt;" width="109">ECC_DAte_BAse </TD><TD class="xl63" style="border-left: none; width: 108pt;" width="144">FAmily </TD><TD class="xl64" style="border-left: none; width: 48pt;" width="64">Sum</TD></TR><TR style="height: 12.75pt;"><TD class="xl66" height="35" rowspan="2" style="border-bottom: .5pt solid silver; height: 26.25pt; border-top: none; width: 82pt;" width="109">17.10.2014</TD><TD class="xl64" style="border-top: none; border-left: none; width: 108pt;" width="144">A</TD><TD class="xl65" style="border-top: none; border-left: none; width: 48pt;" width="64">3</TD></TR><TR style="mso-height-source: userset; height: 13.5pt;"><TD class="xl64" height="18" style="height: 13.5pt; border-top: none; border-left: none; width: 108pt;" width="144">B</TD><TD class="xl65" style="border-top: none; border-left: none; width: 48pt;" width="64">183</TD></TR><TR style="height: 12.75pt;"><TD class="xl66" height="51" rowspan="3" style="border-bottom: .5pt solid silver; height: 38.25pt; border-top: none; width: 82pt;" width="109">24.10.2014</TD><TD class="xl64" style="border-top: none; border-left: none; width: 108pt;" width="144">C</TD><TD class="xl65" style="border-top: none; border-left: none; width: 48pt;" width="64">20</TD></TR><TR style="height: 12.75pt;"><TD class="xl64" height="17" style="height: 12.75pt; border-top: none; border-left: none; width: 108pt;" width="144">A</TD><TD class="xl65" style="border-top: none; border-left: none; width: 48pt;" width="64">7</TD></TR><TR style="height: 12.75pt;"><TD class="xl64" height="17" style="height: 12.75pt; border-top: none; border-left: none; width: 108pt;" width="144">B</TD><TD class="xl65" style="border-top: none; border-left: none; width: 48pt;" width="64">193</TD></TR><TR style="height: 12.75pt;"><TD class="xl66" height="51" rowspan="3" style="border-bottom: .5pt solid silver; height: 38.25pt; border-top: none; width: 82pt;" width="109">31.10.2014</TD><TD class="xl64" style="border-top: none; border-left: none; width: 108pt;" width="144">A</TD><TD class="xl65" style="border-top: none; border-left: none; width: 48pt;" width="64">12</TD></TR><TR style="height: 12.75pt;"><TD class="xl64" height="17" style="height: 12.75pt; border-top: none; border-left: none; width: 108pt;" width="144">B</TD><TD class="xl65" style="border-top: none; border-left: none; width: 48pt;" width="64">1714</TD></TR><TR style="height: 12.75pt;"><TD class="xl64" height="17" style="height: 12.75pt; border-top: none; border-left: none; width: 108pt;" width="144">D</TD><TD class="xl65" style="border-top: none; border-left: none; width: 48pt;" width="64">158</TD></TR><TR style="height: 12.75pt;"><TD class="xl66" height="51" rowspan="3" style="border-bottom: .5pt solid silver; height: 38.25pt; border-top: none; width: 82pt;" width="109">7.11.2014</TD><TD class="xl64" style="border-top: none; border-left: none; width: 108pt;" width="144">C</TD><TD class="xl65" style="border-top: none; border-left: none; width: 48pt;" width="64">16</TD></TR><TR style="height: 12.75pt;"><TD class="xl64" height="17" style="height: 12.75pt; border-top: none; border-left: none; width: 108pt;" width="144">A</TD><TD class="xl65" style="border-top: none; border-left: none; width: 48pt;" width="64">94</TD></TR><TR style="height: 12.75pt;"><TD class="xl64" height="17" style="height: 12.75pt; border-top: none; border-left: none; width: 108pt;" width="144">B</TD><TD class="xl65" style="border-top: none; border-left: none; width: 48pt;" width="64">133</TD></TR><TR style="height: 12.75pt;"><TD class="xl66" height="51" rowspan="3" style="border-bottom: .5pt solid silver; height: 38.25pt; border-top: none; width: 82pt;" width="109">28.11.2014</TD><TD class="xl64" style="border-top: none; border-left: none; width: 108pt;" width="144">C</TD><TD class="xl65" style="border-top: none; border-left: none; width: 48pt;" width="64">85</TD></TR><TR style="height: 12.75pt;"><TD class="xl64" height="17" style="height: 12.75pt; border-top: none; border-left: none; width: 108pt;" width="144">A</TD><TD class="xl65" style="border-top: none; border-left: none; width: 48pt;" width="64">579</TD></TR><TR style="height: 12.75pt;"><TD class="xl64" height="17" style="height: 12.75pt; border-top: none; border-left: none; width: 108pt;" width="144">B</TD><TD class="xl65" style="border-top: none; border-left: none; width: 48pt;" width="64">1713</TD></TR></TBODY></TABLE><P></P><P>we can found that some family info is not in dates.</P><P>just like the 'D', not in 7.11.2014 and 28.11.2014</P><P>but look at the chart, even not data in 7.11.2014, the line still keep in it, what happen? </P><P></P><P><IMG alt="150303_111938_220_CAP.jpg" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/79698_150303_111938_220_CAP.jpg" style="height: 260px; width: 620px;" /></P><P></P><P>suppose it should like this</P><P><IMG alt="2.jpg" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/79699_2.jpg" style="height: 260px; width: 620px;" /></P><P></P><P></P><P>anyone can help ?</P><P></P><P>thanks</P></BODY></HTML> Tue, 03 Mar 2015 03:46:26 GMT https://community.qlik.com/t5/QlikView/the-nonexistent-data-impact-in-stacked-chart/m-p/818345#M288530 guantujiang 2015-03-03T03:46:26Z Re: the nonexistent data impact in stacked chart? https://community.qlik.com/t5/QlikView/the-nonexistent-data-impact-in-stacked-chart/m-p/818346#M288531 <HTML><HEAD></HEAD><BODY><P>I found it work if the 'D' not in 1st position</P><P></P><P>like <IMG alt="3.jpg" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/79703_3.jpg" style="height: 250px; width: 620px;" /></P></BODY></HTML> Tue, 03 Mar 2015 04:47:41 GMT https://community.qlik.com/t5/QlikView/the-nonexistent-data-impact-in-stacked-chart/m-p/818346#M288531 guantujiang 2015-03-03T04:47:41Z Re: the nonexistent data impact in stacked chart? https://community.qlik.com/t5/QlikView/the-nonexistent-data-impact-in-stacked-chart/m-p/818347#M288532 <HTML><HEAD></HEAD><BODY><P>anyone can help ?</P></BODY></HTML> Fri, 06 Mar 2015 05:25:34 GMT https://community.qlik.com/t5/QlikView/the-nonexistent-data-impact-in-stacked-chart/m-p/818347#M288532 guantujiang 2015-03-06T05:25:34Z