Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Contributor II

Order by/Sort by Problems

I am trying to get two fields in the YYYY-MMM formatting to sort newest to oldest without any luck. I format them as Date(MyDate,'YYYY-MMM')  but when I display it in a chat with a simple count of the data it duplicates the Year/Months...

I also tried year(MyDate)&'-'&month(MyDateafter doing an "Order By' in the table below.... this works... but I have two dates I am doing this for. It of course only orders by the first one I list.

Is there a sort expression I can use in the chart itself to sort by a date field? Sort By---> Expression----> Desc----> and maybe =MyDate or something?

1 Solution

Accepted Solutions
Highlighted

Re: Order by/Sort by Problems

Add MonthStart here

Date(MonthStart(MyDate),'YYYY-MMM')

View solution in original post

2 Replies
Highlighted

Re: Order by/Sort by Problems

Add MonthStart here

Date(MonthStart(MyDate),'YYYY-MMM')

View solution in original post

Highlighted
Contributor II

Re: Order by/Sort by Problems

This actually worked perfect, thank you.