Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to sort month

Hi,

Have a look at the attached and see if you have a solution?

Thanks.

10 Replies
johnw
Champion III
Champion III

Use actual month values instead of text or whatever else you might be using today.  So, for instance, if your raw data contains a month number, you could use this:

month(makedate(2011,MonthNumber)) as Month

It doesn't matter what year you plug in.  You're just creating a date temporarily to let QlikView build a month field off of it.  Of course I don't know what your raw data looks like, so that's likely not the exact expression you need.