Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, i currently have a mastercalendar that shows calendar yr from my invoice dates, how do i get it to display as our accounting year rather than calendar yr? Do i amend the Mastercalendar tab attached, or go through the listbox properties of the monthly calendar?
Hi,
Go through the below post.
http://community.qlik.com/blogs/qlikviewdesignblog/2013/05/28/fiscal-year
Regards
ASHFAQ
One way is described here:
http://community.qlik.com/blogs/qlikviewdesignblog/2013/05/28/fiscal-year
HIC
ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='₹ #,##0.00;₹ -#,##0.00';
SET TimeFormat='hh:mm:ss';
SET DateFormat='DD-MM-YYYY';
SET TimestampFormat='DD-MM-YYYY hh:mm:ss[.fff]';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';
Not in the master calendar.
Update in the main tab where we have MonthNames.change the order based on your requirement like below
SET MonthNames='Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec;Jan;Feb;Mar';
It works
thanks to you both, i will give that a whirl
Try to use below code before your calender code:
LoadOrderMonth:
LOAD * Inline [
Order
2000/04/01
2000/05/01
2000/06/01
2000/07/01
2000/08/01
2000/09/01
2000/10/01
2000/11/01
2000/12/01
2000/01/01
2000/02/01
2000/03/01
];
MonthOrder:
Load Month(Order) as Month/////////////////this field name is same as that of calender month field name
Resident LoadOrderMonth;
DROP TABLE LoadOrderMonth;
that did work, but ive now lost my Feb, Mar Apr and May shows as 2013 instead of 14?
(our FY is Sept-Aug)
SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='£#,##0.00;-£#,##0.00';
SET TimeFormat='hh:mm:ss';
SET DateFormat='DD/MM/YYYY';
SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';
SET MonthNames='Sep;Oct;Nov;Dec;Jan;Feb;Mar;Apr;May;Jun;Jul;Aug';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';
First add variable
set FINPERADD = 9; at start of script execution,then
let xdate = mindate;
before you loop starts and then below code
,if(ceil(num(Month(addmonths(date#('$(xdate)','DD-MMM-YYYY'),$(FINPERADD))))/3)=1,'Q1',
if(ceil(num(Month(addmonths(date#('$(xdate)','DD-MMM-YYYY'),$(FINPERADD))))/3)=2,'Q2',
if(ceil(num(Month(addmonths(date#('$(xdate)','DD-MMM-YYYY'),$(FINPERADD))))/3)=3,'Q3','Q4'))) ;
Do we have data for those months?