topic Financial YTD Calculation in QlikView

Financial YTD Calculation

sridhar_sigired — Wed, 16 Nov 2016 15:47:37 GMT

Hi,

Inyeartodate function works for calendar year dates

Ex: Inyeartodate(datefield,today(),0)

Jan1st to today

Can anyone help me to get below dates

YTD - Apr1st to Today

PYTD - Apr1st 2015 to Nov16th 2015.

vinieme12 — Wed, 16 Nov 2016 15:50:18 GMT

Just search for calendar, there are many references available

sunny_talwar — Wed, 16 Nov 2016 15:51:48 GMT

sunny_talwar — Wed, 16 Nov 2016 15:53:36 GMT

So something like this:

YTD

InYearToDate(datefield,today(), 0, 4)

PYTD

InYearToDate(datefield,today(), -1, 4)

shraddha_g — Wed, 16 Nov 2016 15:54:19 GMT

In your syntax, inyeartodate(datefield, today(), 0,4)

For current YTD starting from Apr

And

Inyeartodate(datefield, today(), - 1,4) for prev year YTD starting from Apr

sridhar_sigired — Wed, 16 Nov 2016 15:55:18 GMT

Thank you Sunny, i will check and mark it as correct answer..