Fiscal YTD & Cal YTD

Mon, 19 Sep 2011 06:33:56 GMT

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:

topic Fiscal YTD & Cal YTD in QlikView

Fiscal YTD & Cal YTD

Fiscal YTD & Cal YTD

Fiscal YTD & Cal YTD