topic Re: Pass Previous Year Variable to Expression in QlikView

Pass Previous Year Variable to Expression

Anonymous — Thu, 18 Oct 2018 15:36:53 GMT

I am trying to compare this month to same month last year with a rolling 12 month period for

'Average Daily Contracts Received for Processing per month'

Here is my expression for current year. It aggregates the daily averages for the timespan selected, which is usually fiscal year to date:

=Avg(Aggr($(eNewInBusUnit),Month, Date))

What would be the expression to get previous year's data?

Re: Pass Previous Year Variable to Expression

dplr-rn — Thu, 18 Oct 2018 19:21:20 GMT

put something like below in your set analysis

Year={'$(=Year(Max(DATE))-1)'}

Re: Pass Previous Year Variable to Expression

Anonymous — Thu, 18 Oct 2018 19:39:11 GMT

I'm assuming you mean like this in replacement of 'Month, Date'? However, I am getting the infamous red line under the 1st bracket. Do you know the exact syntax in conjunction with the expression given?

=(Avg(Aggr(($(eNewInBusUnit)),Year={'$(=Year(Max(DATE))-1)'

Re: Pass Previous Year Variable to Expression

dplr-rn — Thu, 18 Oct 2018 20:00:57 GMT

No. I mean repeat same logic as current year with the new set analysis

Let me put it this way whats the expression within eNewInBusUnit

Re: Pass Previous Year Variable to Expression

Anonymous — Fri, 19 Oct 2018 12:00:04 GMT

eNewInBusUnit=count({<DateType={'SLAQueueStart'}>}BusinessUnit)