topic Re: How to use Rank and Aggregate while ignoring a selection? in QlikView https://community.qlik.com/t5/QlikView/How-to-use-Rank-and-Aggregate-while-ignoring-a-selection/m-p/816500#M1037754 <HTML><HEAD></HEAD><BODY><P>Thank you Ruben, that worked perfectly for me!</P></BODY></HTML> Mon, 05 Jan 2015 13:02:22 GMT 2015-01-05T13:02:22Z How to use Rank and Aggregate while ignoring a selection? https://community.qlik.com/t5/QlikView/How-to-use-Rank-and-Aggregate-while-ignoring-a-selection/m-p/816498#M1037752 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P>I want to find the company with the highest sales of the product 'Pencil'. I have a calculated dimension that works when all companies are selected. However, for some reason I need the dimension to work when only one company is selected and that does not work.</P><P></P><P>This is the dimension I use:</P><P>=AGGR(IF(RANK(SUM({1&lt; Year = {2014}, Product = {Pencil}, Companies= &gt;} Sales)) &lt;= 2, Companies), Companies)</P><P></P><P></P><P>Does someone know the solution?</P><P>Many thanks!</P><P></P><P>Mark</P></BODY></HTML> Mon, 05 Jan 2015 12:23:58 GMT https://community.qlik.com/t5/QlikView/How-to-use-Rank-and-Aggregate-while-ignoring-a-selection/m-p/816498#M1037752 2015-01-05T12:23:58Z Re: How to use Rank and Aggregate while ignoring a selection? https://community.qlik.com/t5/QlikView/How-to-use-Rank-and-Aggregate-while-ignoring-a-selection/m-p/816499#M1037753 <HTML><HEAD></HEAD><BODY><P>Hi MArk, if you don't want the selections to filter you can use a dimension like:</P><P>=AGGR(IF(RANK(SUM({1&lt; Year = {2014}, Product = {Pencil}, Companies= &gt;} Sales)) &lt;= 1, Only({1}Companies)), Companies)</P><P>(With "supress null values" checked)</P><P></P><P>and a expression like:</P><P>SUM({1&lt; Year = {2014}, Product = {Pencil}&gt;} Sales)</P></BODY></HTML> Mon, 05 Jan 2015 12:40:12 GMT https://community.qlik.com/t5/QlikView/How-to-use-Rank-and-Aggregate-while-ignoring-a-selection/m-p/816499#M1037753 rubenmarin 2015-01-05T12:40:12Z Re: How to use Rank and Aggregate while ignoring a selection? https://community.qlik.com/t5/QlikView/How-to-use-Rank-and-Aggregate-while-ignoring-a-selection/m-p/816500#M1037754 <HTML><HEAD></HEAD><BODY><P>Thank you Ruben, that worked perfectly for me!</P></BODY></HTML> Mon, 05 Jan 2015 13:02:22 GMT https://community.qlik.com/t5/QlikView/How-to-use-Rank-and-Aggregate-while-ignoring-a-selection/m-p/816500#M1037754 2015-01-05T13:02:22Z