topic Re: Last year to date in QlikView

Last year to date

Thu, 15 Aug 2013 14:14:45 GMT

Hi wizards,

i need your advice.

I have this part of expression:

sum({<Year_financial={$(=max(Year)-1)},Date=.....?????>}(Sale))

Now i want - Calculate sales for last financial year, but only till actual date (i mean today is 15.8.2013, so calculate sales of last financial year till 15.8.2012 - financial year is from april till may, so give me sales from 1.4.2012 to 15.8.2012)

I hope it´s easy for you 😉

Thx a lot

Jaromir

Re: Last year to date

swuehl — Thu, 15 Aug 2013 14:25:45 GMT

Maybe

Date={"<=$(=AddYears(Today(),-1))"}

Re: Last year to date

Fri, 12 Dec 2014 14:47:59 GMT

Hi, Maybe try this

Sum({<YourDate = {'$(=Date(Today()))', '$(=Date(AddYears(Today(), -1)))'} >} SalesAmount)

All the best

Re: Last year to date

erjohnso — Fri, 12 Dec 2014 15:09:11 GMT

Probably not the best solution for days but I created a bookmark "YTD" for my monthly YTD comparisons across several years.