2 Replies Latest reply: Sep 19, 2011 6:15 AM by jeevaguru

Fiscal YTD & Cal YTD

How can we achieve fiscal YTD & Cal YTD in QlikView. Can Anyone Explain?

Regards,

Jeeva.

• Fiscal YTD & Cal YTD

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:

• Fiscal YTD & Cal YTD

Can you explain it. Normally Fiscal year starts from April know? The Same function is applied for calendar year also?

Regards,

Jeeva.