topic Re: Bar chart conditions for ranking in QlikView https://community.qlik.com/t5/QlikView/Bar-chart-conditions-for-ranking/m-p/528046#M1129453 <HTML><HEAD></HEAD><BODY><P>Thank u so much</P></BODY></HTML> Wed, 04 Dec 2013 17:43:18 GMT 2013-12-04T17:43:18Z Bar chart conditions for ranking https://community.qlik.com/t5/QlikView/Bar-chart-conditions-for-ranking/m-p/528044#M1129451 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>i have the counties data on x axis and sales on yaxis .</P><P></P><P>requirement is retrieving the sales data whose rank is less than particular country.</P><P></P><P>suppose display countries sales whose rank less than 'india'.</P><P>pls helpme asap where to write condition and what to write</P><P></P><P>regards</P><P>mahesh t</P></BODY></HTML> Wed, 04 Dec 2013 17:36:45 GMT https://community.qlik.com/t5/QlikView/Bar-chart-conditions-for-ranking/m-p/528044#M1129451 2013-12-04T17:36:45Z Re: Bar chart conditions for ranking https://community.qlik.com/t5/QlikView/Bar-chart-conditions-for-ranking/m-p/528045#M1129452 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Can you provide me a sample file?</P><P></P><P>may be try like this , not sure...</P><P></P><P>=If(Rank(Sum(Sales)) &lt; Rank(Sum({&lt;Country = {'India'}&gt;}Sales)), Sum(Sales))</P></BODY></HTML> Wed, 04 Dec 2013 17:41:16 GMT https://community.qlik.com/t5/QlikView/Bar-chart-conditions-for-ranking/m-p/528045#M1129452 MayilVahanan 2013-12-04T17:41:16Z Re: Bar chart conditions for ranking https://community.qlik.com/t5/QlikView/Bar-chart-conditions-for-ranking/m-p/528046#M1129453 <HTML><HEAD></HEAD><BODY><P>Thank u so much</P></BODY></HTML> Wed, 04 Dec 2013 17:43:18 GMT https://community.qlik.com/t5/QlikView/Bar-chart-conditions-for-ranking/m-p/528046#M1129453 2013-12-04T17:43:18Z Re: Bar chart conditions for ranking https://community.qlik.com/t5/QlikView/Bar-chart-conditions-for-ranking/m-p/528047#M1129454 <HTML><HEAD></HEAD><BODY><P>Ok but i am getting erros can pleas try again fo rme &gt;&gt; check the operator once these thing i am new to set analysis</P></BODY></HTML> Wed, 04 Dec 2013 18:05:02 GMT https://community.qlik.com/t5/QlikView/Bar-chart-conditions-for-ranking/m-p/528047#M1129454 2013-12-04T18:05:02Z Re: Bar chart conditions for ranking https://community.qlik.com/t5/QlikView/Bar-chart-conditions-for-ranking/m-p/528048#M1129455 <HTML><HEAD></HEAD><BODY><P>hi</P><P></P><P>can you post a sample?</P></BODY></HTML> Wed, 04 Dec 2013 19:15:04 GMT https://community.qlik.com/t5/QlikView/Bar-chart-conditions-for-ranking/m-p/528048#M1129455 MayilVahanan 2013-12-04T19:15:04Z