Discussion Board for collaboration on QlikView Scripting.
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
Financial Year vs Calendar
Try like this
LET FROMDate = Today();
LET TODate = Today() + 500;
DAte($(FROMDate) + RowNo()) AS Date,
Month($(FROMDate) + RowNo()) as Month,
Year(YearStart($(FROMDate) + RowNo(), 0, 10)) as Year
AutoGenerate Floor($(TODate) - $(FROMDate));
For Month Sorting use match or try like this
Alt(Text(Month($(FROMDate) + RowNo())), Match(Text(Month($(FROMDate) + RowNo())), 'Oct', 'Nov', 'Dec', 'Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep')) as Month,