topic Rank with selection in QlikView https://community.qlik.com/t5/QlikView/Rank-with-selection/m-p/360424#M133844 <HTML><HEAD></HEAD><BODY><P>Hi All!</P><P></P><P>I have the following expression</P><P>=Aggr( if(Rank(Sum({&lt;Año = {'2012'},Semana_GL = {'$(=$(vMaxSemana)-1)'}, AgpPautaNombre=&gt;}SoutMontoDespTotal)) = 3, AgpPautaNombre), AgpPautaNombre)</P><P></P><P>The idea is that for a specific week in the year, I want to know which AgPautaNombre was in the 3rd place. </P><P>This works ok when I dont have a selection of AgPautaNombre.</P><P></P><P>The thing is that what I really want to do is when I select an AgPautaNombre, I want to know which AgPautaNombre was in the selected AgPautaNombre rank last week, but when I make the selection my textbox goes null. </P><P></P><P>I'm kind of blocked, any Ideas?</P></BODY></HTML> Tue, 20 Mar 2012 18:04:01 GMT 2012-03-20T18:04:01Z Rank with selection https://community.qlik.com/t5/QlikView/Rank-with-selection/m-p/360424#M133844 <HTML><HEAD></HEAD><BODY><P>Hi All!</P><P></P><P>I have the following expression</P><P>=Aggr( if(Rank(Sum({&lt;Año = {'2012'},Semana_GL = {'$(=$(vMaxSemana)-1)'}, AgpPautaNombre=&gt;}SoutMontoDespTotal)) = 3, AgpPautaNombre), AgpPautaNombre)</P><P></P><P>The idea is that for a specific week in the year, I want to know which AgPautaNombre was in the 3rd place. </P><P>This works ok when I dont have a selection of AgPautaNombre.</P><P></P><P>The thing is that what I really want to do is when I select an AgPautaNombre, I want to know which AgPautaNombre was in the selected AgPautaNombre rank last week, but when I make the selection my textbox goes null. </P><P></P><P>I'm kind of blocked, any Ideas?</P></BODY></HTML> Tue, 20 Mar 2012 18:04:01 GMT https://community.qlik.com/t5/QlikView/Rank-with-selection/m-p/360424#M133844 2012-03-20T18:04:01Z Rank with selection https://community.qlik.com/t5/QlikView/Rank-with-selection/m-p/360425#M133845 <HTML><HEAD></HEAD><BODY><P>Any ideas?</P></BODY></HTML> Wed, 21 Mar 2012 16:58:39 GMT https://community.qlik.com/t5/QlikView/Rank-with-selection/m-p/360425#M133845 2012-03-21T16:58:39Z