https://community.qlik.com/t5/QlikView/limit-in-listbox/m-p/1654294#M730424 <P>Sony, would need to use the Max function:</P> <P><A href="https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/AggregationFunctions/max.htm" target="_blank">https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/AggregationFunctions/max.htm</A></P> <P>You will also need the Num function with the Date function I believe to get numeric that will sort for you, and then you may need to convert that back, I am not a guru on this stuff, but my post will kick things back up, so someone else may be able to provide further detail, I just wanted to try to point you in the right direction in the meantime.</P> <P>This design blog post may help with the date functions:</P> <P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/The-Date-Function/ba-p/1463157" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/The-Date-Function/ba-p/1463157</A></P> <P>Sorry I do not have anything better for you.</P> <P>Regards,<BR />Brett</P> Wed, 04 Dec 2019 19:31:55 GMT Brett_Bleess 2019-12-04T19:31:55Z https://community.qlik.com/t5/QlikView/limit-in-listbox/m-p/1649298#M730423 <P>Hi all,</P><P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/46628">@sunny_talwar</a>&nbsp;</P><P>i have date listbox&nbsp; with 2019 nov 1st to&nbsp; nov 20&nbsp; in below format</P><P>DD/MM/YYYY&nbsp;&nbsp;</P><P>&nbsp;</P><P>now i want to show max 10 days in listbox&nbsp; ? how can show this?</P> Sat, 16 Nov 2024 01:53:41 GMT https://community.qlik.com/t5/QlikView/limit-in-listbox/m-p/1649298#M730423 soniasweety 2024-11-16T01:53:41Z https://community.qlik.com/t5/QlikView/limit-in-listbox/m-p/1654294#M730424 <P>Sony, would need to use the Max function:</P> <P><A href="https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/AggregationFunctions/max.htm" target="_blank">https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/AggregationFunctions/max.htm</A></P> <P>You will also need the Num function with the Date function I believe to get numeric that will sort for you, and then you may need to convert that back, I am not a guru on this stuff, but my post will kick things back up, so someone else may be able to provide further detail, I just wanted to try to point you in the right direction in the meantime.</P> <P>This design blog post may help with the date functions:</P> <P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/The-Date-Function/ba-p/1463157" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/The-Date-Function/ba-p/1463157</A></P> <P>Sorry I do not have anything better for you.</P> <P>Regards,<BR />Brett</P> Wed, 04 Dec 2019 19:31:55 GMT https://community.qlik.com/t5/QlikView/limit-in-listbox/m-p/1654294#M730424 Brett_Bleess 2019-12-04T19:31:55Z