https://community.qlik.com/t5/App-Development/text-box/m-p/1810247#M66023 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/134133">@niranjana</a>&nbsp;</P><P>Use Firstsortedvalue() and AGGR() together it will solve the need.</P> Tue, 25 May 2021 06:48:52 GMT Qlik1_User1 2021-05-25T06:48:52Z https://community.qlik.com/t5/App-Development/text-box/m-p/1810099#M66013 <P>Hi</P><P>How to display top 5 countries with least sales in Qliksense Text Box?</P><P>Also , how to display States/Countries in qliksense text box which have Zero sales?</P><P>Thanks in advance</P> Mon, 24 May 2021 16:41:05 GMT https://community.qlik.com/t5/App-Development/text-box/m-p/1810099#M66013 niranjana 2021-05-24T16:41:05Z https://community.qlik.com/t5/App-Development/text-box/m-p/1810247#M66023 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/134133">@niranjana</a>&nbsp;</P><P>Use Firstsortedvalue() and AGGR() together it will solve the need.</P> Tue, 25 May 2021 06:48:52 GMT https://community.qlik.com/t5/App-Development/text-box/m-p/1810247#M66023 Qlik1_User1 2021-05-25T06:48:52Z https://community.qlik.com/t5/App-Development/text-box/m-p/1810284#M66028 <P>Can you pls provide the expression for both scenarios?</P><P>Thanks</P> Tue, 25 May 2021 08:46:34 GMT https://community.qlik.com/t5/App-Development/text-box/m-p/1810284#M66028 niranjana 2021-05-25T08:46:34Z