topic Re: Month order starting April in QlikView

Month order starting April

Fri, 24 Apr 2015 16:22:06 GMT

Hey guys I am using a fiscal calendar where I want my months displaying as beginning from April instead of Jan.

I've used =match(MONTH,'Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec','Jan','Feb','Mar') in the sort order.

Now although it works initially the sort order screws up as soon as you make a selection or filter on any particular dates.

Any ideas please ?

Re: Month order starting April

buzzy996 — Fri, 24 Apr 2015 16:25:39 GMT

try this,if u have master calendar script "SET vFiscalOffset = 6;" just replace 6 with 4 and see?

Re: Month order starting April

maxgro — Fri, 24 Apr 2015 17:45:22 GMT

i think using dual and sort numeric

tmp:

load

date(makedate(2015) + rowno() -1) as date

AutoGenerate 365;

cal:

load

dual(month(date), Mod(month(date)-4, 12)+1) as month,

year(date) as year,

date

Resident tmp;

drop Table tmp;

Re: Month order starting April

MarcoWedel — Fri, 24 Apr 2015 23:42:45 GMT

Hi,

some ressources regarding this topic:

Re: Fiscal calendarby its.anandrjs‌
Fiscal Yearby hic
Fiscal and Standard Calendar generationby jagan‌
Re: Fiscal Calendar Problem‌ by jpe‌
Re: Create fiscal calendarby rwunderlich‌

hope this helps

regards

Marco

Re: Month order starting April

Mon, 27 Apr 2015 10:20:39 GMT

Sorry guys not having a huge amount of joy with this.

My script is as follows :

Date:
LOAD
$(vDateField)
,Month($(vDateField)) as MONTH
,MonthName($(vDateField)) as MONTH_YEAR
,Year($(vDateField)) as YEAR
,'Q'& Ceil(Month($(vDateField))/3) as QUARTER
,Year($(vDateField)) &'-Q'& Ceil(Month($(vDateField)) / 3) as QUARTER_YEAR

////////// Fiscal Year: Apr-Mar
,Year(AddMonths($(vDateField), +3)) as FISCAL_YEAR

,MonthName(AddMonths($(vDateField), -3)) as FISCAL_MONTH_YEAR
,'Q'& Ceil(Month(AddMonths($(vDateField), -3)) / 3) as FISCAL_QUARTER

FROM SOURCE