topic Re: Total in grouped bar chart in QlikView https://community.qlik.com/t5/QlikView/Total-in-grouped-bar-chart/m-p/373926#M574211 <HTML><HEAD></HEAD><BODY><P>If you have the category total in your dimension you could do something like this.</P><P>If (country='Total', avg({$&lt;counrty=&gt;}field),avg(field))</P><P></P><P></P><P>The top 10 you could get with the option in the tab dimension limits.</P><P></P><P></P><P>Hope this helps.</P></BODY></HTML> Fri, 29 Jun 2012 10:34:23 GMT 2012-06-29T10:34:23Z Total in grouped bar chart https://community.qlik.com/t5/QlikView/Total-in-grouped-bar-chart/m-p/373925#M574210 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I want to create my chart like these in screenshot.</P><P>Anyone pls help me out.</P><P></P><P>Bar chart with grouped .</P><P></P><P>And I want to show total in left corner and top 10 countries next.</P></BODY></HTML> Fri, 29 Jun 2012 08:52:55 GMT https://community.qlik.com/t5/QlikView/Total-in-grouped-bar-chart/m-p/373925#M574210 2012-06-29T08:52:55Z Re: Total in grouped bar chart https://community.qlik.com/t5/QlikView/Total-in-grouped-bar-chart/m-p/373926#M574211 <HTML><HEAD></HEAD><BODY><P>If you have the category total in your dimension you could do something like this.</P><P>If (country='Total', avg({$&lt;counrty=&gt;}field),avg(field))</P><P></P><P></P><P>The top 10 you could get with the option in the tab dimension limits.</P><P></P><P></P><P>Hope this helps.</P></BODY></HTML> Fri, 29 Jun 2012 10:34:23 GMT https://community.qlik.com/t5/QlikView/Total-in-grouped-bar-chart/m-p/373926#M574211 2012-06-29T10:34:23Z