topic Re: Bar chart discussopn in QlikView https://community.qlik.com/t5/QlikView/Bar-chart-discussopn/m-p/503350#M1133886 <HTML><HEAD></HEAD><BODY><P>Hello Mahesh,</P><P></P><P>you can use the Set analysis as below.</P><P>=sum( {$&lt;Country = {"=Sum(Sales ) &gt;= 1000 and Sum(Sales ) &lt;= 5000"}&gt;} Sales )</P><P></P><P>Thanks,</P><P>Shruthi</P></BODY></HTML> Thu, 28 Nov 2013 10:02:42 GMT 2013-11-28T10:02:42Z Bar chart discussopn https://community.qlik.com/t5/QlikView/Bar-chart-discussopn/m-p/503349#M1133885 <HTML><HEAD></HEAD><BODY><P>sales data on y axis and country on x-axis i want the data sum of sales range between 1000 and 5000 countries data only.</P><P>let me know any formula for range.</P></BODY></HTML> Thu, 28 Nov 2013 09:35:17 GMT https://community.qlik.com/t5/QlikView/Bar-chart-discussopn/m-p/503349#M1133885 2013-11-28T09:35:17Z Re: Bar chart discussopn https://community.qlik.com/t5/QlikView/Bar-chart-discussopn/m-p/503350#M1133886 <HTML><HEAD></HEAD><BODY><P>Hello Mahesh,</P><P></P><P>you can use the Set analysis as below.</P><P>=sum( {$&lt;Country = {"=Sum(Sales ) &gt;= 1000 and Sum(Sales ) &lt;= 5000"}&gt;} Sales )</P><P></P><P>Thanks,</P><P>Shruthi</P></BODY></HTML> Thu, 28 Nov 2013 10:02:42 GMT https://community.qlik.com/t5/QlikView/Bar-chart-discussopn/m-p/503350#M1133886 2013-11-28T10:02:42Z Re: Bar chart discussopn https://community.qlik.com/t5/QlikView/Bar-chart-discussopn/m-p/503351#M1133887 <HTML><HEAD></HEAD><BODY><P>CHECK attachment</P></BODY></HTML> Thu, 28 Nov 2013 10:56:32 GMT https://community.qlik.com/t5/QlikView/Bar-chart-discussopn/m-p/503351#M1133887 MK_QSL 2013-11-28T10:56:32Z Re: Bar chart discussopn https://community.qlik.com/t5/QlikView/Bar-chart-discussopn/m-p/503352#M1133888 <HTML><HEAD></HEAD><BODY><P>Thank u</P><P>mahesh t</P></BODY></HTML> Thu, 28 Nov 2013 14:01:33 GMT https://community.qlik.com/t5/QlikView/Bar-chart-discussopn/m-p/503352#M1133888 2013-11-28T14:01:33Z Re: Bar chart discussopn https://community.qlik.com/t5/QlikView/Bar-chart-discussopn/m-p/503353#M1133889 <HTML><HEAD></HEAD><BODY><P>Can you close this discussion by selecting Answered or Helpful?</P></BODY></HTML> Thu, 28 Nov 2013 14:39:35 GMT https://community.qlik.com/t5/QlikView/Bar-chart-discussopn/m-p/503353#M1133889 MK_QSL 2013-11-28T14:39:35Z