Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ??
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..
Have you checked this link out?
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
You can use this as your sort expression:
Pick(Month([Fiscal Month]), 10, 11, 12, 1, 2, 3, 4, 5, 6, 7, 8, 9)
do you think i need to calculate fiscal month as i have month in my calender , and i can sort out , will it suffice?
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)
no change at all bu this
Can you share a sample or screenshot of your dimension? Is your MonthYear field read as date or text?
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 1
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