topic Re: Issue with getting same week, last year data in Set Analysis in QlikView

Issue with getting same week, last year data in Set Analysis

hrobertsonqv — Wed, 28 Feb 2018 13:38:18 GMT

I am trying to create a set analysis expression which will count the number of cases within a week from this year compared to the same week last year. I have created Week_No in my calendar table (WeekName(RecordDate)), and I can work out the comparable Week_No from last year as

=WeekName(Week_No-364)

However, in set analysis, I am unable to work out how to add this as a modifier - the nearest I get is:

=count({$<Week_No={$(=WeekName(Week_No-364))}>} Distinct CaseID)

My results table using the above comes out as:

The data table is attached

Grateful for any help here

Re: Issue with getting same week, last year data in Set Analysis

sunny_talwar — Wed, 28 Feb 2018 17:40:38 GMT

Try using this

Above(YourExpression4NoOfCaseThisYear)

Re: Issue with getting same week, last year data in Set Analysis

hrobertsonqv — Thu, 01 Mar 2018 12:10:56 GMT

I need to be able to see on each line the value for (eg) 2018/02 and the corresponding value for 2017/02

If I use 'Above', the value will be the figure for 2018/01 against the line for 2018/02, will it not?

Re: Issue with getting same week, last year data in Set Analysis

sunny_talwar — Thu, 01 Mar 2018 12:15:18 GMT

My bad, you can do it do ways

1) Use The As-Of Table

2) Try with this Above(YourExpression4NoOfCaseThisYear, 12) but make sure you remove any set analysis related to restricting the data to show only 2018

Re: Issue with getting same week, last year data in Set Analysis

hrobertsonqv — Fri, 02 Mar 2018 13:17:42 GMT

Thanks - my problem might be the fact that I am using Dimensions which are date-based as well, so will have to re-think

Thanks anyway