Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
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?
Sony, would need to use the Max function:
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
Sony, would need to use the Max function:
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