topic Chart with percentage in App Development https://community.qlik.com/t5/App-Development/Chart-with-percentage/m-p/1796726#M64388 <P>Hi,</P><P>I have a chart, with dimension: ValueList('Vida','Coche')</P><P>and measure:</P><P>If (ValueList('Vida','Coche')='Vida',(Count([ID])/Count(total [ID])), If (ValueList('Vida','Coche')='Coche',(Count([ID])/Count(total [ID]))))</P><P>I don´t get any error, but I didn´t get the correct results, and also I need in percentage.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="RaquelFQSpain_0-1617481155185.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/52324iFDF920F73FD50D2E/image-size/medium?v=v2&amp;px=400" role="button" title="RaquelFQSpain_0-1617481155185.png" alt="RaquelFQSpain_0-1617481155185.png" /></span></P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>ID</TD><TD>PROVINCIA</TD><TD>COCHE</TD><TD>MOTO</TD><TD>HOGAR</TD><TD>SALUD</TD><TD>DENTAL</TD><TD>VIDA</TD><TD>ACCIDENTES</TD></TR><TR><TD>2</TD><TD>Barcelona</TD><TD>Coche</TD><TD>&nbsp;</TD><TD>Hogar</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>3</TD><TD>Zaragoza</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>Hogar</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>5</TD><TD>Madrid</TD><TD>Coche</TD><TD>Moto</TD><TD>&nbsp;</TD><TD>Salud</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>15</TD><TD>Sevilla</TD><TD>Coche</TD><TD>&nbsp;</TD><TD>Hogar</TD><TD>Salud</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>Accidentes</TD></TR><TR><TD>16</TD><TD>Madrid</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>Hogar</TD><TD>&nbsp;</TD><TD>Dental</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>26</TD><TD>A Coruña</TD><TD>Coche</TD><TD>&nbsp;</TD><TD>Hogar</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>39</TD><TD>Las Palmas</TD><TD>Coche</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>40</TD><TD>Madrid</TD><TD>Coche</TD><TD>Moto</TD><TD>Hogar</TD><TD>Salud</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>60</TD><TD>Barcelona</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>Hogar</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>62</TD><TD>Madrid</TD><TD>Coche</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>68</TD><TD>Madrid</TD><TD>Coche</TD><TD>&nbsp;</TD><TD>Hogar</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>Vida</TD><TD>&nbsp;</TD></TR><TR><TD>89</TD><TD>Madrid</TD><TD>Coche</TD><TD>&nbsp;</TD><TD>Hogar</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>Vida</TD><TD>&nbsp;</TD></TR><TR><TD>104</TD><TD>Madrid</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>Hogar</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>117</TD><TD>Valencia</TD><TD>Coche</TD><TD>&nbsp;</TD><TD>Hogar</TD><TD>&nbsp;</TD><TD>Dental</TD><TD>&nbsp;</TD><TD>Accidentes</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Thanks!</P> Sat, 03 Apr 2021 20:23:23 GMT RaquelFQSpain 2021-04-03T20:23:23Z Chart with percentage https://community.qlik.com/t5/App-Development/Chart-with-percentage/m-p/1796726#M64388 <P>Hi,</P><P>I have a chart, with dimension: ValueList('Vida','Coche')</P><P>and measure:</P><P>If (ValueList('Vida','Coche')='Vida',(Count([ID])/Count(total [ID])), If (ValueList('Vida','Coche')='Coche',(Count([ID])/Count(total [ID]))))</P><P>I don´t get any error, but I didn´t get the correct results, and also I need in percentage.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="RaquelFQSpain_0-1617481155185.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/52324iFDF920F73FD50D2E/image-size/medium?v=v2&amp;px=400" role="button" title="RaquelFQSpain_0-1617481155185.png" alt="RaquelFQSpain_0-1617481155185.png" /></span></P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>ID</TD><TD>PROVINCIA</TD><TD>COCHE</TD><TD>MOTO</TD><TD>HOGAR</TD><TD>SALUD</TD><TD>DENTAL</TD><TD>VIDA</TD><TD>ACCIDENTES</TD></TR><TR><TD>2</TD><TD>Barcelona</TD><TD>Coche</TD><TD>&nbsp;</TD><TD>Hogar</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>3</TD><TD>Zaragoza</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>Hogar</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>5</TD><TD>Madrid</TD><TD>Coche</TD><TD>Moto</TD><TD>&nbsp;</TD><TD>Salud</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>15</TD><TD>Sevilla</TD><TD>Coche</TD><TD>&nbsp;</TD><TD>Hogar</TD><TD>Salud</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>Accidentes</TD></TR><TR><TD>16</TD><TD>Madrid</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>Hogar</TD><TD>&nbsp;</TD><TD>Dental</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>26</TD><TD>A Coruña</TD><TD>Coche</TD><TD>&nbsp;</TD><TD>Hogar</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>39</TD><TD>Las Palmas</TD><TD>Coche</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>40</TD><TD>Madrid</TD><TD>Coche</TD><TD>Moto</TD><TD>Hogar</TD><TD>Salud</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>60</TD><TD>Barcelona</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>Hogar</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>62</TD><TD>Madrid</TD><TD>Coche</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>68</TD><TD>Madrid</TD><TD>Coche</TD><TD>&nbsp;</TD><TD>Hogar</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>Vida</TD><TD>&nbsp;</TD></TR><TR><TD>89</TD><TD>Madrid</TD><TD>Coche</TD><TD>&nbsp;</TD><TD>Hogar</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>Vida</TD><TD>&nbsp;</TD></TR><TR><TD>104</TD><TD>Madrid</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>Hogar</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>117</TD><TD>Valencia</TD><TD>Coche</TD><TD>&nbsp;</TD><TD>Hogar</TD><TD>&nbsp;</TD><TD>Dental</TD><TD>&nbsp;</TD><TD>Accidentes</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Thanks!</P> Sat, 03 Apr 2021 20:23:23 GMT https://community.qlik.com/t5/App-Development/Chart-with-percentage/m-p/1796726#M64388 RaquelFQSpain 2021-04-03T20:23:23Z Re: Chart with percentage https://community.qlik.com/t5/App-Development/Chart-with-percentage/m-p/1796731#M64389 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/135320">@RaquelFQSpain</a>&nbsp;!</P><P>&nbsp; &nbsp; I think you can try this formula</P><LI-CODE lang="markup">If (ValueList('Vida','Coche')='Vida',(Count({&lt;VIDA-={"-"}&gt;}[ID])/Count(total [ID])), If (ValueList('Vida','Coche')='Coche',(Count({&lt;COCHE-={"-"}&gt;}[ID])/Count(total [ID]))))</LI-CODE><P>&nbsp;&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="joaopaulo_delco_0-1617498080454.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/52326i980DDA9B06CBC02A/image-size/medium?v=v2&amp;px=400" role="button" title="joaopaulo_delco_0-1617498080454.png" alt="joaopaulo_delco_0-1617498080454.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P> Sun, 04 Apr 2021 01:01:34 GMT https://community.qlik.com/t5/App-Development/Chart-with-percentage/m-p/1796731#M64389 joaopaulo_delco 2021-04-04T01:01:34Z Re: Chart with percentage https://community.qlik.com/t5/App-Development/Chart-with-percentage/m-p/1796779#M64400 <P>Thank you so much!!!!!</P> Sun, 04 Apr 2021 22:17:37 GMT https://community.qlik.com/t5/App-Development/Chart-with-percentage/m-p/1796779#M64400 RaquelFQSpain 2021-04-04T22:17:37Z Re: Chart with percentage https://community.qlik.com/t5/App-Development/Chart-with-percentage/m-p/1796915#M64426 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/135320">@RaquelFQSpain</a>&nbsp;!</P><P>&nbsp; &nbsp;I think you mark as solution the wrong post.</P> Mon, 05 Apr 2021 14:47:44 GMT https://community.qlik.com/t5/App-Development/Chart-with-percentage/m-p/1796915#M64426 joaopaulo_delco 2021-04-05T14:47:44Z