Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
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.