topic More qvd chart plotting woes... in QlikView https://community.qlik.com/t5/QlikView/More-qvd-chart-plotting-woes/m-p/146647#M25174 <HTML><HEAD></HEAD><BODY><P>Hello again,<BR />Sorry for bombarding this forum recently. Thanks to all for your time and help.<BR /><BR />My latest issue..<BR />I am plotting a chart based on the data from qvdfs which are read in - each having a snapshot_date field, so I can plot a trend.<BR />The chart shows a count of different severities in each file, with the snapshot_date value along the x-axis.<BR /><BR />I want to show the count of each severity as a percentage or relative. However, when more than one qvd is loaded in, it takes it relative to the entire data-set, not the individual qvd files.</P><P>As you can see from the attached qvw, each fo the three graphs should have bars going up to 100% - which it does with only one qvd loaded in. This has 2 qvd's.<BR /><BR />I appreciate any assistance you can offer with this.<BR />Matt</P></BODY></HTML> Fri, 12 Jun 2009 15:09:13 GMT 2009-06-12T15:09:13Z More qvd chart plotting woes... https://community.qlik.com/t5/QlikView/More-qvd-chart-plotting-woes/m-p/146647#M25174 <HTML><HEAD></HEAD><BODY><P>Hello again,<BR />Sorry for bombarding this forum recently. Thanks to all for your time and help.<BR /><BR />My latest issue..<BR />I am plotting a chart based on the data from qvdfs which are read in - each having a snapshot_date field, so I can plot a trend.<BR />The chart shows a count of different severities in each file, with the snapshot_date value along the x-axis.<BR /><BR />I want to show the count of each severity as a percentage or relative. However, when more than one qvd is loaded in, it takes it relative to the entire data-set, not the individual qvd files.</P><P>As you can see from the attached qvw, each fo the three graphs should have bars going up to 100% - which it does with only one qvd loaded in. This has 2 qvd's.<BR /><BR />I appreciate any assistance you can offer with this.<BR />Matt</P></BODY></HTML> Fri, 12 Jun 2009 15:09:13 GMT https://community.qlik.com/t5/QlikView/More-qvd-chart-plotting-woes/m-p/146647#M25174 2009-06-12T15:09:13Z More qvd chart plotting woes... https://community.qlik.com/t5/QlikView/More-qvd-chart-plotting-woes/m-p/146648#M25175 <HTML><HEAD></HEAD><BODY><P>count(RiskSeverity)/count(total &lt;SnapshotDate&gt; RiskSeverity)</P><P>Remove the "relative" checkmark, and format as a percentage.</P></BODY></HTML> Sat, 13 Jun 2009 00:31:16 GMT https://community.qlik.com/t5/QlikView/More-qvd-chart-plotting-woes/m-p/146648#M25175 johnw 2009-06-13T00:31:16Z