Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Have a look at the attached and see if you have a solution?
Thanks.
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.