Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Financial Yr rather than Calendar yr

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?

20 Replies
ashfaq_haseeb
Champion III
Champion III

hic
Former Employee
Former Employee

Anonymous
Not applicable
Author

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

Anonymous
Not applicable
Author

thanks to you both, i will give that a whirl

Not applicable
Author

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;

Anonymous
Not applicable
Author

that did work, but ive now lost my Feb, Mar Apr and May shows as 2013 instead of 14? 

Capture.JPG.jpg

Anonymous
Not applicable
Author

(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';

Not applicable
Author

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'))) ;

Anonymous
Not applicable
Author

Do we have data for those months?