topic Concat + ListLoop + sort of date in QlikView

Concat + ListLoop + sort of date

CarloRomagnano — Fri, 12 Feb 2021 09:57:12 GMT

=Concat(DayName(MonthEnd(now(1),ValueLoop(-12,1,1))),chr(10),????)

This expression returns dates sorted as text instead of date! How do I substitute ????
So the unwanted result:

28/02/2021
29/02/2020
30/04/2020
30/06/2020
30/09/2020
30/11/2020
31/01/2021
31/03/2020
31/03/2021
31/05/2020
31/07/2020
31/08/2020
31/10/2020
31/12/2020

I want this:

29/02/2020
31/03/2020
31/03/2021
30/04/2020
31/05/2020
30/06/2020
31/07/2020
31/08/2020
30/09/2020
31/10/2020
30/11/2020
31/12/2020
31/01/2021
28/02/2021

Re: Concat + ListLoop + sort of date

Frank_Hartmann — Fri, 12 Feb 2021 14:08:40 GMT

try this expression:

=Concat(DayName(MonthEnd(now(1),ValueLoop(-12,1,1))),chr(10),DayName(MonthEnd(now(1),ValueLoop(-12,1,1))))

Re: Concat + ListLoop + sort of date

CarloRomagnano — Mon, 22 Feb 2021 08:39:00 GMT

Thank you!

This is the final solution adopted (I need it in the listbox of input box in descending order till the previous end of month):

=Concat(DayName(MonthEnd(now(1),ValueLoop(-12,-1,1))),';',-DayName(MonthEnd(now(1),ValueLoop(-12,-1,1))))