topic Re: Set analysis with previous week data issue in QlikView

Set analysis with previous week data issue

Wed, 25 Nov 2020 16:16:04 GMT

I need a reference date which eqauls last week in my set ananlysis.

Like for example:

sum({$<ReferenceDate = {'24/07/2016'}>} _Saldo) - sum({$<VervallenSegmStatus = {'Actueel'}, ReferenceDate = {'24/07/2016'}>} _Saldo)

But the date which is now fixed should be able to change.

Like for example:

sum({$<ReferenceDate = {"week(ReferenceDate) -1"}>} _Saldo) - sum({$<VervallenSegmStatus = {'Actueel'}, ReferenceDate = {"week(ReferenceDate) -1"}>} _Saldo)

So the code in bold is not working at the moment.

Can someone help me with this problem?

Thanks!

Re: Set analysis with previous week data issue

Wed, 03 Aug 2016 12:30:48 GMT

use this

ReferenceDate - 7

weekstart(ReferenceDate -7)

Re: Set analysis with previous week data issue

Thu, 04 Aug 2016 08:12:06 GMT

Hello Rodrigo,

Thanks for your answer!

But can you give me some more information because I can't get it working.

So you mean {"week(ReferenceDate) -7"} ? Because like this it doesn't work.

Re: Set analysis with previous week data issue

Thu, 04 Aug 2016 09:42:35 GMT

You can discard my last question. I solved the problem.

Instead of using ReferenceDate, I made a ReferenceWeek in my script like this:

week(ReferenceDate) as ReferenceWeek

and then I used following expression:

=sum({$<ReferenceWeek = {"$(=ReferenceWeek -1)"}, ReferenceDate = >} _Saldo)

With this code I got it working!