topic Re: Ignoring selections on Dimensions in QlikView https://community.qlik.com/t5/QlikView/Ignoring-selections-on-Dimensions/m-p/967301#M647471 <HTML><HEAD></HEAD><BODY><P>If you want to override selections on a specific dimension you can use something like sum({&lt;DimA, DimB&gt;} Amount). In this case selections in the fields DimA and DimB are ignored when calculated the sum of Amount.</P></BODY></HTML> Thu, 01 Oct 2015 05:58:18 GMT Gysbert_Wassenaar 2015-10-01T05:58:18Z Ignoring selections on Dimensions https://community.qlik.com/t5/QlikView/Ignoring-selections-on-Dimensions/m-p/967300#M647470 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P>Ive been trying to create a bar char where can user all the Years as Dimensions.</P><P>The thing is need the dimensions to ignore the selections because the last year is all-ready selected.</P><P></P><P>I need the Year to be in the dimension because it has to Stacked with other dimension (local Delivery).</P><P></P><P>As i need all years (Distinct years i mean) to appear in the Dimension i cant use something like sum({1}year) to ignore the selections.</P><P></P><P>I will attach picture of the result i would like to get (but in this case with the Year Clean)</P><P></P><P>Can anyone help me with this?</P></BODY></HTML> Wed, 30 Sep 2015 09:16:31 GMT https://community.qlik.com/t5/QlikView/Ignoring-selections-on-Dimensions/m-p/967300#M647470 2015-09-30T09:16:31Z Re: Ignoring selections on Dimensions https://community.qlik.com/t5/QlikView/Ignoring-selections-on-Dimensions/m-p/967301#M647471 <HTML><HEAD></HEAD><BODY><P>If you want to override selections on a specific dimension you can use something like sum({&lt;DimA, DimB&gt;} Amount). In this case selections in the fields DimA and DimB are ignored when calculated the sum of Amount.</P></BODY></HTML> Thu, 01 Oct 2015 05:58:18 GMT https://community.qlik.com/t5/QlikView/Ignoring-selections-on-Dimensions/m-p/967301#M647471 Gysbert_Wassenaar 2015-10-01T05:58:18Z