topic how do i represent data count in % on Gauge in QlikView https://community.qlik.com/t5/QlikView/how-do-i-represent-data-count-in-on-Gauge/m-p/686501#M248706 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>Find attached qvw file. i want to prepare 6 gauges to count in % the total number of persons in each directorate.</P><P></P><P>Regards</P></BODY></HTML> Wed, 30 Jul 2014 19:18:00 GMT Anonymous 2014-07-30T19:18:00Z how do i represent data count in % on Gauge https://community.qlik.com/t5/QlikView/how-do-i-represent-data-count-in-on-Gauge/m-p/686501#M248706 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>Find attached qvw file. i want to prepare 6 gauges to count in % the total number of persons in each directorate.</P><P></P><P>Regards</P></BODY></HTML> Wed, 30 Jul 2014 19:18:00 GMT https://community.qlik.com/t5/QlikView/how-do-i-represent-data-count-in-on-Gauge/m-p/686501#M248706 Anonymous 2014-07-30T19:18:00Z Re: how do i represent data count in % on Gauge https://community.qlik.com/t5/QlikView/how-do-i-represent-data-count-in-on-Gauge/m-p/686502#M248707 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I attached a version of your app, with the 6 gauges.</P><P></P><P>Eduardo</P></BODY></HTML> Wed, 30 Jul 2014 19:42:42 GMT https://community.qlik.com/t5/QlikView/how-do-i-represent-data-count-in-on-Gauge/m-p/686502#M248707 eduardo_sommer 2014-07-30T19:42:42Z Re: how do i represent data count in % on Gauge https://community.qlik.com/t5/QlikView/how-do-i-represent-data-count-in-on-Gauge/m-p/686503#M248708 <HTML><HEAD></HEAD><BODY><P>if I understand</P><P></P><P>count({$&lt;Directorate={CHQ}&gt;} DISTINCT Name) / count(TOTAL DISTINCT Name)</P><P>repeat for every Directorate/gauge</P><P></P><P></P><P>what about a simple bar chart? </P><P><IMG alt="1.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/63431_1.png" style="width: auto; height: auto;" /></P></BODY></HTML> Wed, 30 Jul 2014 19:48:28 GMT https://community.qlik.com/t5/QlikView/how-do-i-represent-data-count-in-on-Gauge/m-p/686503#M248708 maxgro 2014-07-30T19:48:28Z Re: how do i represent data count in % on Gauge https://community.qlik.com/t5/QlikView/how-do-i-represent-data-count-in-on-Gauge/m-p/686504#M248709 <HTML><HEAD></HEAD><BODY><P>See attached file</P></BODY></HTML> Wed, 30 Jul 2014 19:53:50 GMT https://community.qlik.com/t5/QlikView/how-do-i-represent-data-count-in-on-Gauge/m-p/686504#M248709 rustyfishbones 2014-07-30T19:53:50Z Re: Re: how do i represent data count in % on Gauge https://community.qlik.com/t5/QlikView/how-do-i-represent-data-count-in-on-Gauge/m-p/686505#M248710 <HTML><HEAD></HEAD><BODY><P>See attached, apologies the last post did not have the correct calculation for R &amp; P</P></BODY></HTML> Wed, 30 Jul 2014 19:57:50 GMT https://community.qlik.com/t5/QlikView/how-do-i-represent-data-count-in-on-Gauge/m-p/686505#M248710 rustyfishbones 2014-07-30T19:57:50Z Re: how do i represent data count in % on Gauge https://community.qlik.com/t5/QlikView/how-do-i-represent-data-count-in-on-Gauge/m-p/686506#M248711 <HTML><HEAD></HEAD><BODY><P>I couldn't understand the question.</P><P></P><P>Eduardo</P></BODY></HTML> Wed, 30 Jul 2014 20:12:56 GMT https://community.qlik.com/t5/QlikView/how-do-i-represent-data-count-in-on-Gauge/m-p/686506#M248711 eduardo_sommer 2014-07-30T20:12:56Z Re: how do i represent data count in % on Gauge https://community.qlik.com/t5/QlikView/how-do-i-represent-data-count-in-on-Gauge/m-p/686507#M248712 <HTML><HEAD></HEAD><BODY><P>Please mark which is the correct answer</P></BODY></HTML> Wed, 30 Jul 2014 20:14:12 GMT https://community.qlik.com/t5/QlikView/how-do-i-represent-data-count-in-on-Gauge/m-p/686507#M248712 rustyfishbones 2014-07-30T20:14:12Z