topic Current YTD vs Previous year YTD in QlikView

Current YTD vs Previous year YTD

rsdhavle — Thu, 08 May 2014 07:38:54 GMT

We are trying to compare current year YTD vs Prev year YTD. Lets say we are in month of May 2014 so current year YTD would be Jan to May 2014 revenue. And we need to compare this with previous yr YTD revenue which should be Jan to May 2013 so how can we write and expression so that the prev year YTD will calculate only these 5 months Jan to May 2013 and exclude rest while calculating revenue?

Re: Current YTD vs Previous year YTD

tresB — Thu, 08 May 2014 07:45:31 GMT

Several ways are there. A better one : Year Over Year Comparison

Re: Current YTD vs Previous year YTD

its_anandrjs — Thu, 08 May 2014 07:46:20 GMT

Write like

For Current YTD

=SUM({$<YourDateField = {'>=$(=YearStart(Today()))<=$(=MonthEnd(Today()))'}>}Sales)

For Previous YTD

=SUM({$<YoureDateField = {'>=$(=AddMonths( YearStart (Today()),-12))<=$(=AddMonths( MonthEnd (Today()),-12))'}>}Sales)

Re: Current YTD vs Previous year YTD

rajat2392 — Thu, 08 May 2014 07:52:19 GMT

Current Year- Sum({<Date={">=YearStart(Today())<=$(=Today())"}>}Sales)

Previous Year- Sum({<Date={">=$(=YearStart($(=MakeDate(Year(Today())-1,Month(Today()),Day(Today())))))<=$(=MakeDate(Year(Today())-1,Month(Today()),Day(Today())))"}>}Sales)

Re: Current YTD vs Previous year YTD

Mon, 16 Nov 2015 08:19:21 GMT

Hello @Anand Chouhan

I used your code:

=Count({$<BookingDate = {'>=$(=YearStart(Today()))<=$(=MonthEnd(Today()))'}>}AssignmentNumber)

=Count({$<BookingDate = {'>=$(=AddMonths( YearStart (Today()),-12))<=$(=AddMonths( MonthEnd (Today()),-12))'}>}AssignmentNumber)

It works perfectly.

Then I wanted to add another preceding year.. Following same form.. but this did not work at all.. Any idea how to make this work?

=Count({$<BookingDate = {'>=$(=AddMonths( YearStart (Today()),-24))<=$(=AddMonths( MonthEnd (Today()),-24))’}>}AssignmentNumber)

Thanks

/Oskar