Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
j_tupper
Contributor
Contributor

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
Employee
Employee

jebamalai
Specialist
Specialist

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

j_tupper
Contributor
Contributor
Author

thanks to you both, i will give that a whirl

Not applicable

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;

j_tupper
Contributor
Contributor
Author

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

Capture.JPG.jpg

j_tupper
Contributor
Contributor
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

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

jebamalai
Specialist
Specialist

Do we have data for those months?