Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
MalcolmCICWF
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

Re: Order by/Sort by Problems

Add MonthStart here

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

2 Replies

Re: Order by/Sort by Problems

Add MonthStart here

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

MalcolmCICWF
Contributor II

Re: Order by/Sort by Problems

This actually worked perfect, thank you.

Community Browser