topic Problem with months in QlikView

Problem with months

Thu, 22 Aug 2013 13:52:58 GMT

Hey, i have the following problem

I have a field month in QV like 1.2.3.4.5...

I want them appearing like "Jan, Feb, Mar".. but in order.

I mean, i put something like this:

If month=1, Jan, If month=2, Feb....

But dont know how to order them... because when i select anything else, they get mixed. "Mar,Feb,Jun,Apr"

Any solution??

Thanks

MayilVahanan — Thu, 22 Aug 2013 13:58:08 GMT

Try with Mapping and ApplyMap concept to achieve this

MapTable:

Mapping Load * inline

[

Month, MonthName

1,Jan

2,Feb

!2,Dec

];

Load ApplyMap('MapTable',Month) as Month, * from tablename;

Hope it helps

Brice-SACCUCCI — Thu, 22 Aug 2013 14:05:25 GMT

Hi,

here is a way to get the correct month value, which will have the right sorting order.

MonthNum:

LOAD * INLINE

[

monthNum

3];

LOAD

monthNum,

month(MakeDate(2013, monthNum)) as Month

RESIDENT

MonthNum;