https://community.qlik.com/t5/App-Development/Using-Aggr-and-Rank-in-Set-Analysis/m-p/1884605#M72866 <P>The following measure successfully creates a field called Rank that ranks multiple lines within a Quote based on&nbsp;Quote Extended Price. I need to use the table where this is in to send out an NPrinting report with a filter on Rank = 1. However, as far as I can tell, we cannot use a calculated dimension in a filter.&nbsp;</P> <P>Aggr(Rank(Sum({&lt;[Quote Date]={"$(=Date(Today()-1))"},[Intercompany Flag]={'$(vIntercompany)'}, DateType={'Quote Date'}&gt;}[Quote Extended Price]),2,2), [Quote Number],[%ItemKey])</P> <P>My next thought was that I have to integrate above aggr/rank code into the other measure called "Amount" that I have in the table in order to limit the data to Rank = 1.</P> <P>The measure is: Sum({&lt;[Quote Date]={"$(=Date(Today()-1))"},[Intercompany Flag]={'$(vIntercompany)'}, DateType={'Quote Date'}&gt;}[Quote Extended Price])</P> <P>Please let me know if this is possible or if there is a better way to achieve this.&nbsp;</P> <P>&nbsp;</P> Mon, 24 Jan 2022 15:29:45 GMT ManuelLindekeit 2022-01-24T15:29:45Z https://community.qlik.com/t5/App-Development/Using-Aggr-and-Rank-in-Set-Analysis/m-p/1884605#M72866 <P>The following measure successfully creates a field called Rank that ranks multiple lines within a Quote based on&nbsp;Quote Extended Price. I need to use the table where this is in to send out an NPrinting report with a filter on Rank = 1. However, as far as I can tell, we cannot use a calculated dimension in a filter.&nbsp;</P> <P>Aggr(Rank(Sum({&lt;[Quote Date]={"$(=Date(Today()-1))"},[Intercompany Flag]={'$(vIntercompany)'}, DateType={'Quote Date'}&gt;}[Quote Extended Price]),2,2), [Quote Number],[%ItemKey])</P> <P>My next thought was that I have to integrate above aggr/rank code into the other measure called "Amount" that I have in the table in order to limit the data to Rank = 1.</P> <P>The measure is: Sum({&lt;[Quote Date]={"$(=Date(Today()-1))"},[Intercompany Flag]={'$(vIntercompany)'}, DateType={'Quote Date'}&gt;}[Quote Extended Price])</P> <P>Please let me know if this is possible or if there is a better way to achieve this.&nbsp;</P> <P>&nbsp;</P> Mon, 24 Jan 2022 15:29:45 GMT https://community.qlik.com/t5/App-Development/Using-Aggr-and-Rank-in-Set-Analysis/m-p/1884605#M72866 ManuelLindekeit 2022-01-24T15:29:45Z