https://community.qlik.com/t5/QlikView/Non-calculated-dimensions-ignoring-selection/m-p/1565966#M597222 <P>Hello.&nbsp;</P><P>I am trying to have the dimension Purchase requester ignore all those fields when selected. They are irrelevant and when I select one of them it is causing null data because i know it is there. This is not a calculated field. Does anyone see anything wrong with this or if this is the effective strategy for what I am trying to do. Any assistance would be greatly appreciated.&nbsp;</P><P>=Aggr(Only({&lt;[Month]=, [Year]= ,QTR= ,[Month Num]= ,[Month -Short-]= ,Month= ,[GL Period]= ,[CC]= ,[GL Act]= , [PO Creation Date] = {"=Year(Only({1}[PO Creation Date])) &gt;= $(v3PrevYear)"}&gt;}[Purchase Requester]),[Purchase Requester])</P><P>Thank You</P> Fri, 05 Apr 2019 17:56:42 GMT eli_K12 2019-04-05T17:56:42Z https://community.qlik.com/t5/QlikView/Non-calculated-dimensions-ignoring-selection/m-p/1565966#M597222 <P>Hello.&nbsp;</P><P>I am trying to have the dimension Purchase requester ignore all those fields when selected. They are irrelevant and when I select one of them it is causing null data because i know it is there. This is not a calculated field. Does anyone see anything wrong with this or if this is the effective strategy for what I am trying to do. Any assistance would be greatly appreciated.&nbsp;</P><P>=Aggr(Only({&lt;[Month]=, [Year]= ,QTR= ,[Month Num]= ,[Month -Short-]= ,Month= ,[GL Period]= ,[CC]= ,[GL Act]= , [PO Creation Date] = {"=Year(Only({1}[PO Creation Date])) &gt;= $(v3PrevYear)"}&gt;}[Purchase Requester]),[Purchase Requester])</P><P>Thank You</P> Fri, 05 Apr 2019 17:56:42 GMT https://community.qlik.com/t5/QlikView/Non-calculated-dimensions-ignoring-selection/m-p/1565966#M597222 eli_K12 2019-04-05T17:56:42Z