topic Re: exclude data in charts based on filtering in App Development https://community.qlik.com/t5/App-Development/exclude-data-in-charts-based-on-filtering/m-p/33256#M2216 <HTML><HEAD></HEAD><BODY><P>Can you share some sample? What codes you want to show or hide. This can be done in multiple ways - Using if statement or only function in set analysis.</P></BODY></HTML> Fri, 15 Jun 2018 18:06:46 GMT isingh30 2018-06-15T18:06:46Z exclude data in charts based on filtering https://community.qlik.com/t5/App-Development/exclude-data-in-charts-based-on-filtering/m-p/33255#M2215 <HTML><HEAD></HEAD><BODY><P><SPAN>I'm approaching Qlik sense but I have difficulty with the syntax.</SPAN></P><P></P><P><SPAN lang="EN-US" style="color: black;">I have a data table with the following fields:</SPAN></P><P><SPAN lang="EN-US" style="color: black;">- company code (only 2 values: firm1 and firm2)</SPAN></P><P><SPAN lang="EN-US" style="color: black;">- client code</SPAN></P><P><SPAN lang="EN-US" style="color: black;">- year</SPAN></P><P><SPAN lang="EN-US" style="color: black;">- amount</SPAN></P><P></P><P><SPAN lang="EN-US" style="color: black;">I created a chart that shows me the values by year and everything works correctly.</SPAN></P><P><SPAN lang="EN-US" style="color: black;">Now I would like to exclude some customer codes when I select both companies on the filters.</SPAN></P><P><SPAN lang="EN-US" style="color: black;">I tried to write a condition in the chart but I can not find the correct syntax or write it in the wrong place.</SPAN></P><P><SPAN lang="EN-US" style="color: black;">Can someone help me?</SPAN></P><P style="margin-bottom: .0001pt;"><SPAN lang="EN-US" style="color: black;">Thank you so much</SPAN></P></BODY></HTML> Fri, 15 Jun 2018 11:54:45 GMT https://community.qlik.com/t5/App-Development/exclude-data-in-charts-based-on-filtering/m-p/33255#M2215 Anonymous 2018-06-15T11:54:45Z Re: exclude data in charts based on filtering https://community.qlik.com/t5/App-Development/exclude-data-in-charts-based-on-filtering/m-p/33256#M2216 <HTML><HEAD></HEAD><BODY><P>Can you share some sample? What codes you want to show or hide. This can be done in multiple ways - Using if statement or only function in set analysis.</P></BODY></HTML> Fri, 15 Jun 2018 18:06:46 GMT https://community.qlik.com/t5/App-Development/exclude-data-in-charts-based-on-filtering/m-p/33256#M2216 isingh30 2018-06-15T18:06:46Z