topic System Variables in QlikView

System Variables

Anonymous — Wed, 25 Jan 2012 11:37:57 GMT

Hello

This may be a very stupid question, but can somebody tell me how i use the 'Number interpretation variables'.

On load i am setting a system variable call 'LongMonthNames'. If i have a date '02/06/2012' how can i use 'LongMonthNames' to return June.

I have attached a file with Months 1 to 12 so you can see what i mean.

LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';

Cheers

Robbie

System Variables

Wed, 25 Jan 2012 12:19:09 GMT

Robbie,

All the functions seem to use the format as defiend in MonthNames eg if you change your script to:

load Month,

month(Month) as monthname;

LOAD * INLINE [

Month

];

It will return 'Jan' 'Feb' etc. The LongMonthNames only seems to have a value when formatting a date (MMM returns eg 'Jan' whereas 'MMMM' returns 'January'.

Easiest way I know is to just change the definition of MonthNames:

SET MonthNames='January;February;March;April;May;June;July;August;September;October;November;December';

Regards,

Gordon

System Variables

stephencredmond — Wed, 25 Jan 2012 12:22:15 GMT

Hi Robbie,

The values will be used in the Date format function when you use MMMM:

Load Dual(Text(Date(MakeDate(2012, Month), 'MMMM')), Month) As Month;

LOAD * INLINE [

Month

];

Regards,

Stephen

System Variables

Anonymous — Wed, 25 Jan 2012 13:08:23 GMT

Thanks guys, that makes sense now!!