limit in listbox

[soniasweety]

Hi all,

@sunny_talwar 

i have date listbox  with 2019 nov 1st to  nov 20  in below format

DD/MM/YYYY  

now i want to show max 10 days in listbox  ? how can show this?

[Brett_Bleess · Accepted solution]

Sony, would need to use the Max function:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/Aggre...

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.

This design blog post may help with the date functions:

https://community.qlik.com/t5/Qlik-Design-Blog/The-Date-Function/ba-p/1463157

Sorry I do not have anything better for you.

Regards,
Brett