topic Re: get only 2 min numbers in QlikView https://community.qlik.com/t5/QlikView/get-only-2-min-numbers/m-p/89785#M14615 <HTML><HEAD></HEAD><BODY><P>=Concat(DISTINCT {&lt;Number={"=Rank(<STRONG style="color: #ff0000;">-</STRONG>Number)&lt;3"}&gt;} Number, ',')</P></BODY></HTML> Thu, 20 Sep 2018 06:43:59 GMT tresB 2018-09-20T06:43:59Z get only 2 min numbers https://community.qlik.com/t5/QlikView/get-only-2-min-numbers/m-p/89784#M14614 <HTML><HEAD></HEAD><BODY><P>HI All,</P><P></P><P>I have a field where it has some random numbers.</P><P></P><P>For example: 1,10, 2,4,14,6,7,8...</P><P></P><P>Now i need to get only 2 min numbers.</P><P></P><P>Output should be 1,2.</P><P></P><P>Can you please tell me on this.</P><P></P><P>Thanks,</P><P>Bharat</P></BODY></HTML> Thu, 20 Sep 2018 06:38:47 GMT https://community.qlik.com/t5/QlikView/get-only-2-min-numbers/m-p/89784#M14614 bharatkishore 2018-09-20T06:38:47Z Re: get only 2 min numbers https://community.qlik.com/t5/QlikView/get-only-2-min-numbers/m-p/89785#M14615 <HTML><HEAD></HEAD><BODY><P>=Concat(DISTINCT {&lt;Number={"=Rank(<STRONG style="color: #ff0000;">-</STRONG>Number)&lt;3"}&gt;} Number, ',')</P></BODY></HTML> Thu, 20 Sep 2018 06:43:59 GMT https://community.qlik.com/t5/QlikView/get-only-2-min-numbers/m-p/89785#M14615 tresB 2018-09-20T06:43:59Z