topic Re: Selecting values to exclude from chart in QlikView https://community.qlik.com/t5/QlikView/Selecting-values-to-exclude-from-chart/m-p/780654#M276613 <HTML><HEAD></HEAD><BODY><P>Of course. Thank you!</P></BODY></HTML> Tue, 24 Mar 2015 15:39:26 GMT 2015-03-24T15:39:26Z Selecting values to exclude from chart https://community.qlik.com/t5/QlikView/Selecting-values-to-exclude-from-chart/m-p/780652#M276611 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P></P><P>I have a chart with sum(Amounts). Is there a way that I can create a list box or table where the user can select values that the expression will exclude/ignore?</P><P></P><P>For example, a list box with top 10 [Orders] (ranked by sum(Amounts)) that the user could select to see the effect on the chart without them.</P><P></P><P>Thanks!</P></BODY></HTML> Tue, 24 Mar 2015 14:01:57 GMT https://community.qlik.com/t5/QlikView/Selecting-values-to-exclude-from-chart/m-p/780652#M276611 2015-03-24T14:01:57Z Re: Selecting values to exclude from chart https://community.qlik.com/t5/QlikView/Selecting-values-to-exclude-from-chart/m-p/780653#M276612 <HTML><HEAD></HEAD><BODY><P>You can add a Field Event Trigger at Document Property (CTRL+ALT+D),</P><P>Select the target Field in your listbox</P><P>add an "On Select" Action, Action Type : "Select Excluded", select the field you want to apply the Exclusion</P></BODY></HTML> Tue, 24 Mar 2015 14:51:29 GMT https://community.qlik.com/t5/QlikView/Selecting-values-to-exclude-from-chart/m-p/780653#M276612 jpenuliar 2015-03-24T14:51:29Z Re: Selecting values to exclude from chart https://community.qlik.com/t5/QlikView/Selecting-values-to-exclude-from-chart/m-p/780654#M276613 <HTML><HEAD></HEAD><BODY><P>Of course. Thank you!</P></BODY></HTML> Tue, 24 Mar 2015 15:39:26 GMT https://community.qlik.com/t5/QlikView/Selecting-values-to-exclude-from-chart/m-p/780654#M276613 2015-03-24T15:39:26Z