topic Re: How do I refer to LongMonthNames variable in script in QlikView

How do I refer to LongMonthNames variable in script

cliff_clayman — Wed, 02 Nov 2016 16:15:02 GMT

I would like to use the variable LongMonthNames in my script, but I cannot figure out what the syntax should be.

Month(OrderDate) AS Month,

This is what I currently have. What do I need to change the variable to so I can utilize the Long Month Names variable that is created in the Main script?

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';

Re: How do I refer to LongMonthNames variable in script

Frank_Hartmann — Wed, 02 Nov 2016 16:47:43 GMT

try using only this

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

hope this helps

Re: How do I refer to LongMonthNames variable in script

cliff_clayman — Wed, 02 Nov 2016 16:50:34 GMT

No, I do not want to do that. I want to use the LongMonthNames variable.

Re: How do I refer to LongMonthNames variable in script

Frank_Hartmann — Wed, 02 Nov 2016 16:55:22 GMT

then use this:

=Date(Month,'MMMM')

hope this helps

Re: How do I refer to LongMonthNames variable in script

cliff_clayman — Wed, 02 Nov 2016 16:55:58 GMT

What is the point of QlikView adding the LongMonthNames variable if I can't use it?

Re: How do I refer to LongMonthNames variable in script

Frank_Hartmann — Wed, 02 Nov 2016 16:57:19 GMT

Date(Month,'MMMM') will call the longmonthname according your script!

Re: How do I refer to LongMonthNames variable in script

cliff_clayman — Wed, 02 Nov 2016 16:58:47 GMT

You do not reference the field name in that code...

Re: How do I refer to LongMonthNames variable in script

Frank_Hartmann — Wed, 02 Nov 2016 17:07:52 GMT

But by transforming into 'MMMM' Qlikview calls the Variable LongMonthNames in Script!

Re: How do I refer to LongMonthNames variable in script

cliff_clayman — Wed, 02 Nov 2016 17:56:36 GMT

Okay, I used the following code:

Date(OrderDate,'MMMM') AS Month

I am getting multiple values for the months whereas I am only expecting one value for each month name. When I use the original code,

Month(OrderDate) AS Month

I only get each individual month name.

Also, is the function called MonthsName used for long month names? It appears to require 2 parameters.

Re: How do I refer to LongMonthNames variable in script

maxgro — Wed, 02 Nov 2016 18:30:42 GMT

try

Dual( date(OrderDate, 'MMMM'), Month(OrderDate)) AS Month