topic TOP 1 in a TOP 3 in QlikView https://community.qlik.com/t5/QlikView/TOP-1-in-a-TOP-3/m-p/315364#M1196680 <HTML><HEAD></HEAD><BODY><P>Hi everyone !</P><P>I want to show in a text box a TOP 1 of a TOP 3.</P><P>I a have a list, in this list i take the 3 best order by sales. In this TOP 3, I just want to show the number 1 order by the marge.</P><P>Someone can help me ?</P><P>I join an example : in the first text box it shows the top 3, but i can't calculate the TOP 1, and show this in a text box.</P><P>Thanks a lot</P><P></P></BODY></HTML> Tue, 22 Mar 2011 09:37:43 GMT 2011-03-22T09:37:43Z TOP 1 in a TOP 3 https://community.qlik.com/t5/QlikView/TOP-1-in-a-TOP-3/m-p/315364#M1196680 <HTML><HEAD></HEAD><BODY><P>Hi everyone !</P><P>I want to show in a text box a TOP 1 of a TOP 3.</P><P>I a have a list, in this list i take the 3 best order by sales. In this TOP 3, I just want to show the number 1 order by the marge.</P><P>Someone can help me ?</P><P>I join an example : in the first text box it shows the top 3, but i can't calculate the TOP 1, and show this in a text box.</P><P>Thanks a lot</P><P></P></BODY></HTML> Tue, 22 Mar 2011 09:37:43 GMT https://community.qlik.com/t5/QlikView/TOP-1-in-a-TOP-3/m-p/315364#M1196680 2011-03-22T09:37:43Z TOP 1 in a TOP 3 https://community.qlik.com/t5/QlikView/TOP-1-in-a-TOP-3/m-p/315365#M1196681 <HTML><HEAD></HEAD><BODY><P>Try this in a Text Box:</P><P></P><P>=firstsortedvalue(distinct AccountName,-marge)</P><P>Hope that helps,</P><P>Matt - Visual Analytics Ltd</P></BODY></HTML> Tue, 22 Mar 2011 10:13:50 GMT https://community.qlik.com/t5/QlikView/TOP-1-in-a-TOP-3/m-p/315365#M1196681 matt_crowther 2011-03-22T10:13:50Z TOP 1 in a TOP 3 https://community.qlik.com/t5/QlikView/TOP-1-in-a-TOP-3/m-p/315366#M1196682 <HTML><HEAD></HEAD><BODY><P>Thx for your answers!</P><P>But it doesn't work because i'm using rank fonction to have the TOP 3. And this function returns only the ACcountName. So if i use "firstsortedvalue", i don't have the marge colunm, so it doesn't work <span class="lia-unicode-emoji" title=":disappointed_face:">😞</span></P></BODY></HTML> Tue, 22 Mar 2011 10:45:33 GMT https://community.qlik.com/t5/QlikView/TOP-1-in-a-TOP-3/m-p/315366#M1196682 2011-03-22T10:45:33Z