topic plotting_chart in QlikView

topic plotting_chart in QlikView https://community.qlik.com/t5/QlikView/plotting-chart/m-p/469833#M560717 <HTML><HEAD></HEAD><BODY><P>Dear all</P><P></P><P>the data below showed</P><P>  </P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Status</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>OS</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>%</STRONG></SPAN></TH></TR><TR><TD>PF</TD><TD>5,114,949,319</TD><TD>80.9</TD></TR><TR><TD>WL</TD><TD>298,711,690</TD><TD>4.7</TD></TR><TR><TD>Impaired</TD><TD>912,029,846</TD><TD>14.4</TD></TR><TR><TD></TD><TD>6,325,690,885</TD><TD>100</TD></TR></TBODY></TABLE><P></P><P>But when I plot the chart, it comes out like </P><P>80.3%</P><P>4.7%</P><P>15.0%</P><P></P><P>I use expression sum(os)/sum(Total <snapshot_dt> os) with dimension of snalpsot_dt and status.</P><P></P><P>Anyone could help</P><P></P><P>rgrds</P></BODY></HTML> Fri, 19 Apr 2013 01:22:15 GMT 2013-04-19T01:22:15Z plotting_chart https://community.qlik.com/t5/QlikView/plotting-chart/m-p/469833#M560717 <HTML><HEAD></HEAD><BODY><P>Dear all</P><P></P><P>the data below showed</P><P>  </P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Status</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>OS</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>%</STRONG></SPAN></TH></TR><TR><TD>PF</TD><TD>5,114,949,319</TD><TD>80.9</TD></TR><TR><TD>WL</TD><TD>298,711,690</TD><TD>4.7</TD></TR><TR><TD>Impaired</TD><TD>912,029,846</TD><TD>14.4</TD></TR><TR><TD></TD><TD>6,325,690,885</TD><TD>100</TD></TR></TBODY></TABLE><P></P><P>But when I plot the chart, it comes out like </P><P>80.3%</P><P>4.7%</P><P>15.0%</P><P></P><P>I use expression sum(os)/sum(Total <snapshot_dt> os) with dimension of snalpsot_dt and status.</P><P></P><P>Anyone could help</P><P></P><P>rgrds</P></BODY></HTML> Fri, 19 Apr 2013 01:22:15 GMT https://community.qlik.com/t5/QlikView/plotting-chart/m-p/469833#M560717 2013-04-19T01:22:15Z