topic CALENDAR TO MONTH ? in QlikView

CALENDAR TO MONTH ?

Anonymous — Mon, 30 Mar 2015 10:24:48 GMT

i have calender jan as 1st month & dec as 12th month

but i want to get the output as july as 1st month & oct as 12th month how ?

Re: CALENDAR TO MONTH ?

PrashantSangle — Mon, 30 Mar 2015 10:28:35 GMT

Hi,

Create Inline table

LOAD * INLINE[

MonthName,Month

July,1

Oct,12

...

];

Regards

Re: CALENDAR TO MONTH ?

sagarkharpude — Mon, 30 Mar 2015 10:29:14 GMT

Try this in sort tab->Expression

=wildmatch(Monthfield,'Jul','Aug','Sep', 'May','Oct')

or create the inline table as follows in script:

load * inline

[

monthname,monthnumber

Jul,1

Aug,2

Oct,12

];

Re: CALENDAR TO MONTH ?

avinashelite — Mon, 30 Mar 2015 10:33:42 GMT

you can try to set it in the edit script by the setting the set statements

SET MonthNames='Jul;Aug;Sep;Okt;Nov;Dez;Jan;Feb;Mrz;Apr;Mai;Jun';

Create a calender of your own

Re: CALENDAR TO MONTH ?

Mon, 30 Mar 2015 10:39:37 GMT

Hi,

If you are trying it in script.

load * inline

[

monthname,monthnumber

Jul,1

Aug,2

Oct,12

];

Re: CALENDAR TO MONTH ?

hic — Mon, 30 Mar 2015 12:38:41 GMT

You should create a master calendar of your own. See e.g. this blog post: Fiscal Year.

You should NOT change the environment variable in the script (The "SET MonthNames=" statement) since you then will rename the months, i.e. you will get the 'July' label for the month of January. No, you should use

Mod(Month-$(vFM), 12)+1 as MonthNo

to calculate a fiscal month number in addition to the Gregorian (the real) month number. The vFM variable is the number for the first month of the fiscal year.

HIC