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: 
yogitamehta10
Creator
Creator

how to calculate fiscal month starting from april.

HI All,

i want to show data in bar graph from fiscal month ,  my fiscal month if starting form april , i have normal month in my calender ,

how to calculate fiscal month ??

1 Solution

Accepted Solutions
NickHoff
Specialist
Specialist

Can also add a sort expression like the following:

match(only({1}[%MonthNumField]), '4','5','6','7','8','9','10','11','12','1','2','3')

You can change the field to what your data uses and the numbers could be text like 'April', 'May','June', etc.etc..

View solution in original post

29 Replies
marcus_sommer

sunny_talwar

Have you checked this link out?

Fiscal and Standard Calendar generation

yogitamehta10
Creator
Creator
Author

Actually i  just need to sort  it by April  to march .. how to do that . i'm using qliksense

my month   is mmm-yyyy .

Please suggest

sunny_talwar

You can use this as your sort expression:

Pick(Month([Fiscal Month]), 10, 11, 12, 1,  2, 3, 4, 5, 6, 7, 8, 9)

yogitamehta10
Creator
Creator
Author

do you think i need to calculate fiscal month  as i have  month in my calender  , and i can sort out , will it suffice?

sunny_talwar

I forgot that you don't have fiscal month

Try this:

Pick(Month(MonthField), 10, 11, 12, 1,  2, 3, 4, 5, 6, 7, 8, 9)

yogitamehta10
Creator
Creator
Author

no change at all bu this

sunny_talwar

Can you share a sample or screenshot of your dimension? Is your MonthYear field read as date or text?

NickHoff
Specialist
Specialist

Add the bottom section to your Master Calendar.  TempDate would be the date you generated for your master calendar as shown below:


TempCalendar:
//Left Keep (PayCore)
LOAD
$(vDateMin) + RowNo() - 1 AS DateNumber
Date($(vDateMin) + RowNo() - 1) AS TempDate 
AUTOGENERATE
WHILE $(vDateMin)+IterNo()-1<= $(vDateMax)



LET vFactor = 3;   //offset for calculating fiscal year


//Fiscal Dates
Num(Month(AddMonths(TempDate,$(vFactor))),00) AS FiscalMonthNum,
'FY ' &
Right(Year(AddMonths(TempDate,$(vFactor))),2) AS FiscalYearDesc,
Year(AddMonths(TempDate,$(vFactor)))&'|'&Num(Month(AddMonths(TempDate,$(vFactor))),00) as %Fiscal_Key,
Year(AddMonths(TempDate,$(vFactor)))&'-'&Num(Month(AddMonths(TempDate,$(vFactor))),00) as FYRPR,
Year(AddMonths(TempDate,$(vFactor))) as FiscalYear,
'FY ' &
Right(Year(AddMonths(TempDate,$(vFactor))),2)& ' Q' & Ceil(Month(AddMonths(TempDate,$(vFactor)))/3) AS FiscalYearQuarter