Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
CarloRomagnano
Contributor
Contributor

Concat + ListLoop + sort of date

=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

1 Solution

Accepted Solutions
Frank_Hartmann
Master II
Master II

try this expression:

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

View solution in original post

2 Replies
Frank_Hartmann
Master II
Master II

try this expression:

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

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))))