topic bar chart develop exclude the some records in QlikView https://community.qlik.com/t5/QlikView/bar-chart-develop-exclude-the-some-records/m-p/711900#M1063321 <HTML><HEAD></HEAD><BODY><P>i have one dimension like this 'status'.the&nbsp; data like op, recom, app, close, gp....etc. and sales column&nbsp; I develop the one bar chart using this fields.</P><P></P><P>I need develop the only op,recom,app (remaining are exclude) data using to develop the bar chart. how to do that.plz tell me...</P></BODY></HTML> Tue, 16 Sep 2014 16:42:29 GMT 2014-09-16T16:42:29Z bar chart develop exclude the some records https://community.qlik.com/t5/QlikView/bar-chart-develop-exclude-the-some-records/m-p/711900#M1063321 <HTML><HEAD></HEAD><BODY><P>i have one dimension like this 'status'.the&nbsp; data like op, recom, app, close, gp....etc. and sales column&nbsp; I develop the one bar chart using this fields.</P><P></P><P>I need develop the only op,recom,app (remaining are exclude) data using to develop the bar chart. how to do that.plz tell me...</P></BODY></HTML> Tue, 16 Sep 2014 16:42:29 GMT https://community.qlik.com/t5/QlikView/bar-chart-develop-exclude-the-some-records/m-p/711900#M1063321 2014-09-16T16:42:29Z Re: bar chart develop exclude the some records https://community.qlik.com/t5/QlikView/bar-chart-develop-exclude-the-some-records/m-p/711901#M1063322 <HTML><HEAD></HEAD><BODY><P>use set analysis</P><P>in expression</P><P>=sum({&lt;status={'op','recom','app'}&gt;}sales)</P><P>this will do.</P><P></P><P>-Sundar</P></BODY></HTML> Tue, 16 Sep 2014 17:00:27 GMT https://community.qlik.com/t5/QlikView/bar-chart-develop-exclude-the-some-records/m-p/711901#M1063322 sundarakumar 2014-09-16T17:00:27Z