topic Data completeness report in QlikView https://community.qlik.com/t5/QlikView/Data-completeness-report/m-p/445385#M567731 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I am looking to create a QlikView chart report to display the percentage of particular fields which contain a value. So:</P><P></P><P>First Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 99%</P><P>Last Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100%</P><P>Job Title&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 97%</P><P>Job Level&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 88%</P><P>Job Function&nbsp;&nbsp;&nbsp;&nbsp; 92%</P><P>Company&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 99%</P><P>City&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 92%</P><P>Country&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 91%</P><P>etc...</P><P></P><P>I can do this as multiple single metric gauge charts but as there are quite a few values to display I was hoping to have one bar chart with each field represented by a bar plotted on a range of 0-100%. Any ideas how I might achieve this.</P><P></P><P>Thanks</P><P>Jon</P></BODY></HTML> Mon, 19 Nov 2012 11:37:44 GMT 2012-11-19T11:37:44Z Data completeness report https://community.qlik.com/t5/QlikView/Data-completeness-report/m-p/445385#M567731 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I am looking to create a QlikView chart report to display the percentage of particular fields which contain a value. So:</P><P></P><P>First Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 99%</P><P>Last Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100%</P><P>Job Title&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 97%</P><P>Job Level&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 88%</P><P>Job Function&nbsp;&nbsp;&nbsp;&nbsp; 92%</P><P>Company&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 99%</P><P>City&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 92%</P><P>Country&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 91%</P><P>etc...</P><P></P><P>I can do this as multiple single metric gauge charts but as there are quite a few values to display I was hoping to have one bar chart with each field represented by a bar plotted on a range of 0-100%. Any ideas how I might achieve this.</P><P></P><P>Thanks</P><P>Jon</P></BODY></HTML> Mon, 19 Nov 2012 11:37:44 GMT https://community.qlik.com/t5/QlikView/Data-completeness-report/m-p/445385#M567731 2012-11-19T11:37:44Z