topic Re: YTD Calculation in QlikView

YTD Calculation

Anonymous — Tue, 24 Mar 2015 05:39:54 GMT

Hi All,

I am having a appln that I need to calulcate YTD with below logic. My financial year start at 4th month so when I click May
I need to get cumulative values of Apr and May. Same applies till March.

Re: YTD Calculation

Anonymous — Tue, 24 Mar 2015 06:04:51 GMT

The YearTodate function have got Starting month as 3rd argument, you can mention 4 (april) as you starting month

2nd argument is an offset 0 refers to this year, -1 referes to last year +1 refers to next year same periods

YearTodate(Date,0,4,Today())

Re: YTD Calculation

Anonymous — Tue, 24 Mar 2015 06:14:55 GMT

Hi Bhagirath,

Thanks for your reply. Actually I dont have any issues in date field,also I have created a Financial year which start from Apr,

All I need is,to have a Exp that should calculate in above mentioned manner

Re: YTD Calculation

Tue, 24 Mar 2015 06:38:19 GMT

hi,

use it

variable vMAxDate=max(Date)

=Sum({$<Fin_Year=,Month=>}InYearToDate(Date,'$(vMaxDate)',0,4) * -1 *((Value)))

Regards

Vimlesh

Re: YTD Calculation

Tue, 24 Mar 2015 06:40:44 GMT

Hi,

Check App.

Regards

Vimlesh