topic Re: Bar chart design in QlikView https://community.qlik.com/t5/QlikView/Bar-chart-design/m-p/345058#M573750 <HTML><HEAD></HEAD><BODY><P>Thank you guys, works perfectly!!!</P></BODY></HTML> Wed, 11 Jul 2012 10:32:48 GMT 2012-07-11T10:32:48Z Bar chart design https://community.qlik.com/t5/QlikView/Bar-chart-design/m-p/345055#M573743 <HTML><HEAD></HEAD><BODY><P>Hello everyone,</P><P></P><P>Can anybody help me with bar char? Files with problem description attached,</P><P></P><P></P><P>Thanks in advance!</P></BODY></HTML> Wed, 11 Jul 2012 08:12:06 GMT https://community.qlik.com/t5/QlikView/Bar-chart-design/m-p/345055#M573743 2012-07-11T08:12:06Z Re: Bar chart design https://community.qlik.com/t5/QlikView/Bar-chart-design/m-p/345056#M573744 <HTML><HEAD></HEAD><BODY><P>You can try a calculated dimension like</P><P></P><P><EM>=aggr(rank(total sum(Revenue)), Client,Country)</EM></P><P></P><P></P><P>Hope this helps,</P><P>Stefan</P></BODY></HTML> Wed, 11 Jul 2012 08:21:33 GMT https://community.qlik.com/t5/QlikView/Bar-chart-design/m-p/345056#M573744 swuehl 2012-07-11T08:21:33Z Re: Bar chart design https://community.qlik.com/t5/QlikView/Bar-chart-design/m-p/345057#M573748 <HTML><HEAD></HEAD><BODY><P>Try using the following as dimension: (see file attached)&nbsp;&nbsp; aggr (if(Rank(sum(Revenue))&lt;=30,Rank(Total Aggr(Sum(Revenue), Client, Country)),'-'),Client,Country)</P></BODY></HTML> Wed, 11 Jul 2012 08:34:42 GMT https://community.qlik.com/t5/QlikView/Bar-chart-design/m-p/345057#M573748 2012-07-11T08:34:42Z Re: Bar chart design https://community.qlik.com/t5/QlikView/Bar-chart-design/m-p/345058#M573750 <HTML><HEAD></HEAD><BODY><P>Thank you guys, works perfectly!!!</P></BODY></HTML> Wed, 11 Jul 2012 10:32:48 GMT https://community.qlik.com/t5/QlikView/Bar-chart-design/m-p/345058#M573750 2012-07-11T10:32:48Z