topic Re: define fiscal year calendar in script with min & max date in QlikView

define fiscal year calendar in script with min & max date

Wed, 16 Jul 2014 08:17:22 GMT

Hi guys

I don't get a financial calendar

I have following things:

CONNECT TO XYZ;

Load [Posting Date],

Month([Posting Date]) as Month,

Year([Posting Date]) as Year;

SQL SELECT [Posting Date] FROM XYZ;

My intention is to create a calendar with the financial section which is from October YEAR to septemer YEAR+

It would be nice to create a FROM - TO calendar in to tables

And my 2. lil question is: How can I fix the order of the Month ? with Match?

Because in my database it starts from another date, not october ..

Best regards, Tobias

Re: define fiscal year calendar in script with min & max date

Wed, 16 Jul 2014 08:41:29 GMT

Financial Year vs Calendar

Re: define fiscal year calendar in script with min & max date

jagan — Wed, 16 Jul 2014 09:20:02 GMT

Hi,

Try like this

LET FROMDate = Today();

LET TODate = Today() + 500;

Calendar:

Load

RowNo(),

DAte($(FROMDate) + RowNo()) AS Date,

Month($(FROMDate) + RowNo()) as Month,

Year(YearStart($(FROMDate) + RowNo(), 0, 10)) as Year

AutoGenerate Floor($(TODate) - $(FROMDate));

REgards,

Jagan.

Re: define fiscal year calendar in script with min & max date

jagan — Wed, 16 Jul 2014 10:08:55 GMT

Hi,

For Month Sorting use match or try like this

Calendar:

Load

RowNo(),

DAte($(FROMDate) + RowNo()) AS Date,

Alt(Text(Month($(FROMDate) + RowNo())), Match(Text(Month($(FROMDate) + RowNo())), 'Oct', 'Nov', 'Dec', 'Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep')) as Month,

Year(YearStart($(FROMDate) + RowNo(), 0, 10)) as Year

AutoGenerate Floor($(TODate) - $(FROMDate));

Regards,

Jagan.