topic Exclude values from a chart in QlikView https://community.qlik.com/t5/QlikView/Exclude-values-from-a-chart/m-p/221967#M74716 <HTML><HEAD></HEAD><BODY><P>Hi all, beautiful day here in London today.</P><P>Is there an easy way to exclude a single dimension value from a chart? For example, I have a chart showing currency balances by date. The data runs from 31/12/2009 up to today, but I only want the chart to display balances for this year.</P><P>I guess I could add a 'Year' field based on the date and then just select 2010, but I'm just curious to know if there is a way I can choose to exclude a value from those available in a list box?</P><P>TIA</P><P>Tony</P></BODY></HTML> Thu, 22 Apr 2010 14:31:06 GMT 2010-04-22T14:31:06Z Exclude values from a chart https://community.qlik.com/t5/QlikView/Exclude-values-from-a-chart/m-p/221967#M74716 <HTML><HEAD></HEAD><BODY><P>Hi all, beautiful day here in London today.</P><P>Is there an easy way to exclude a single dimension value from a chart? For example, I have a chart showing currency balances by date. The data runs from 31/12/2009 up to today, but I only want the chart to display balances for this year.</P><P>I guess I could add a 'Year' field based on the date and then just select 2010, but I'm just curious to know if there is a way I can choose to exclude a value from those available in a list box?</P><P>TIA</P><P>Tony</P></BODY></HTML> Thu, 22 Apr 2010 14:31:06 GMT https://community.qlik.com/t5/QlikView/Exclude-values-from-a-chart/m-p/221967#M74716 2010-04-22T14:31:06Z Exclude values from a chart https://community.qlik.com/t5/QlikView/Exclude-values-from-a-chart/m-p/221968#M74717 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>probably you can use set analysis</P><P>sum({1&lt;year={2010}&gt;}balances)</P><P></P><P>thanks</P></BODY></HTML> Thu, 22 Apr 2010 14:40:32 GMT https://community.qlik.com/t5/QlikView/Exclude-values-from-a-chart/m-p/221968#M74717 2010-04-22T14:40:32Z Exclude values from a chart https://community.qlik.com/t5/QlikView/Exclude-values-from-a-chart/m-p/221969#M74718 <HTML><HEAD></HEAD><BODY><P>Thanks Tauqueer, that's what I suspected. I guess I was hoping for a right-click menu option to exclude the selected item.</P><P>Maybe a request for v10.....</P><P>cheers,</P><P>Tony</P></BODY></HTML> Thu, 22 Apr 2010 17:16:57 GMT https://community.qlik.com/t5/QlikView/Exclude-values-from-a-chart/m-p/221969#M74718 2010-04-22T17:16:57Z