Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can we achieve fiscal YTD & Cal YTD in QlikView. Can Anyone Explain?
Regards,
Jeeva.
The below fiscal year conversion code : note here fiscal year started from July
if( num(Month(OrderDate))>6,Year(OrderDate)+1,Year(OrderDate)) as FiscalYear, // Converting Year in Fiscal year
'Q' & Ceil(If(num(Month(OrderDate))<=6,Right('00'&num(Month(OrderDate)+6),2),Right('00'&(num(Month(OrderDate))-6),2))/3) as FiscalQuarter, // Converting Quarter in Fiscal Quarter
If(num(Month(OrderDate))<=6,Right(num(Month(OrderDate)+6),2),Right((num(Month(OrderDate))-6),2))as FiscalMonth,// Converting Month in
Fiscal Month
=sum({$<FiscalYear = {$(=max(FiscalYear))}, FiscalMonth = {"<=$(=max({<FiscalYear={$(=max(FiscalYear))}>} FiscalMonth))>"}>} Sales*vCurrency)/1000
YTD:
Can you explain it. Normally Fiscal year starts from April know? The Same function is applied for calendar year also?
Regards,
Jeeva.