Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Fiscal YTD & Cal YTD

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

Regards,

Jeeva.

2 Replies
Not applicable

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:

Not applicable

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.

Community Browser