topic Getting Prior Year in Set Analysis in QlikView

Getting Prior Year in Set Analysis

timothyj — Tue, 22 Sep 2015 19:24:45 GMT

I am stuck with a bit of set analysis. I want to display this year's and last year's totals, using year as a dimension. I can get everything but have to enter last year. I cannot get anything to work. Any help? The formula I am using is:

=Sum({1<[Sale WeekNum]={"=Week(GetFieldSelections([Sale Week Of]))"}>*(1<[Sale Year]={"=Year(GetFieldSelections([Sale Week Of]))"}> + 1<[Sale Year]={"2014"}>)}[SALE FLAG])

Again, if I replace 2014 with any formula, I lose those. I have tried many variations of {"=Year(GetFieldSelections([Sale Week Of]))-1"} to no avail. I have tried AddMonths. Thanks for your help. (I hope I have posted this in the correct place.)

Re: Getting Prior Year in Set Analysis

arulsettu — Wed, 23 Sep 2015 06:39:51 GMT

try this

replace this

1<[Sale Year]={"2014"}

with this

datefield={">=$(=Num(YearStart(Max(datefield), -1)))<=$(=AddYear(Max(datefield), -1))"}

Re: Getting Prior Year in Set Analysis

timothyj — Wed, 23 Sep 2015 12:07:00 GMT

Between the time I submitted this and it was posted, I got a working solution for the previous year:

<[Sale Year]={$(=Year(GetFieldSelections([Sale Week Of]))-1)}>

I also changed:

<[Sale Year]={"=Year(GetFieldSelections([Sale Week Of]))"}>

<[Sale Year]={$(=Year(GetFieldSelections([Sale Week Of])))}>

I am going to have to study up on the difference between using quotation marks and dollar sign expansion in expressions.

Thanks!