Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rsdhavle
Creator II
Creator II

Current YTD vs Previous year YTD

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?

4 Replies
tresesco
MVP
MVP

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

its_anandrjs

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)

rajat2392
Partner - Creator III
Partner - Creator III

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)

Not applicable

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