Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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.