topic How to filter data in a chart? in QlikView https://community.qlik.com/t5/QlikView/How-to-filter-data-in-a-chart/m-p/1432601#M430737 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>In Qlik View there is a chart, in this chart I want to exclude one value. This chart is based up on certain columns and in one column different production types are shown. Beside this chart there are several list boxes and with these list boxes it is possible to filter some production types off or on. </P><P>But one specific production type must be removed out of the sheet. But I don't know how this is possible? </P><P>First I thought with a filter within the expressions. I've used : IF(Line_Cells_HUB='Wheels',Null(),Line_Cells_HUB)</P><P></P><P>But unfortunately this doesn't work or I am making a mistake. </P><P></P><P>Hopefully someone call help me. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 25 Oct 2017 13:07:05 GMT Anonymous 2017-10-25T13:07:05Z How to filter data in a chart? https://community.qlik.com/t5/QlikView/How-to-filter-data-in-a-chart/m-p/1432601#M430737 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>In Qlik View there is a chart, in this chart I want to exclude one value. This chart is based up on certain columns and in one column different production types are shown. Beside this chart there are several list boxes and with these list boxes it is possible to filter some production types off or on. </P><P>But one specific production type must be removed out of the sheet. But I don't know how this is possible? </P><P>First I thought with a filter within the expressions. I've used : IF(Line_Cells_HUB='Wheels',Null(),Line_Cells_HUB)</P><P></P><P>But unfortunately this doesn't work or I am making a mistake. </P><P></P><P>Hopefully someone call help me. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 25 Oct 2017 13:07:05 GMT https://community.qlik.com/t5/QlikView/How-to-filter-data-in-a-chart/m-p/1432601#M430737 Anonymous 2017-10-25T13:07:05Z Re: How to filter data in a chart? https://community.qlik.com/t5/QlikView/How-to-filter-data-in-a-chart/m-p/1432602#M430738 <HTML><HEAD></HEAD><BODY><P>Hi Demi,</P><P>In this case we can use calculated dimension by using pick match. Could you please attach the sample data set so that I can work around and give the solution properly.</P></BODY></HTML> Sun, 05 Nov 2017 17:27:23 GMT https://community.qlik.com/t5/QlikView/How-to-filter-data-in-a-chart/m-p/1432602#M430738 anshulsri 2017-11-05T17:27:23Z Re: How to filter data in a chart? https://community.qlik.com/t5/QlikView/How-to-filter-data-in-a-chart/m-p/1432603#M430739 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>Thankyou for the help, but unfortunately that isn't possible because I can't share de data with others </P></BODY></HTML> Wed, 22 Nov 2017 13:49:15 GMT https://community.qlik.com/t5/QlikView/How-to-filter-data-in-a-chart/m-p/1432603#M430739 Anonymous 2017-11-22T13:49:15Z