Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
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))))