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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
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.

Labels (1)
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.