topic Re: Compare data with previous data in QlikView

Compare data with previous data

f1234567 — Wed, 25 Nov 2020 16:16:04 GMT

Hello everybody,

I am struggling with a possibly simple task.

I have upload-dates for each record, i.e.

e.g.

Prod, Marker, loaded

A, , 01.01.2017

B, A, 01.01.2017

A, , 15.01.2017

B, , 15.01.2017

C, , 15.01.2017

D, , 15.01.2017

A, , 01.02.2017

B, A, 01.02.2017

C, , 01.02.2017

D, , 15.02.2017

E, , 15.02.2017

A, , 01.03.2017

B, A, 01.03.2017

C, A, 02.03.2017

D, A, 02.03.2017

Now, I would like to select ONE Date, e.g. "01.02.2017" and compare each product with the PREVIOUS data load.

So first thing to happen is that QV should find out what was the previous date. In the example it would be "15.01.2017".

Then compare the selection "01.02.2017" with "previous" (=> 15.01.2017) and find those products that have "Marker" = A on date of selection and had NO Marker on previous date.

So the result I would like to see only those with marker A (that had no marker on previous date, 15.1.2015):

Prod	Marker	loaded
B	A	01.02.2017

I have tried with previous() and peek() and others and have had no success.

Hopefully one of you experts have a Suggestion for me.

Many thanks in advance!

Re: Compare data with previous data

Anil_Babu_Samineni — Mon, 23 Apr 2018 13:33:30 GMT

If you select below? Is that output you are expecting?

Re: Compare data with previous data

f1234567 — Mon, 23 Apr 2018 13:46:17 GMT

Hi there!
Thanks very much. But what I need is, that the user clicks on ONE Date only.

Say we click on "01.02.2017".

QV checks what was the previous data set, i.e., 15.01.2017, and then finds out that on 15.01. there was no marker compared to 01.02. where there is a marker "A" for the product B.

In other words: a click on 01.02.2017 should give below result.

It should select those products which have been marked at the date selected when comparing it with the last date.

Prod	Marker	loaded
B	A	01.02.2017

Re: Compare data with previous data

Mark_Little — Mon, 23 Apr 2018 14:34:55 GMT

! !HI Frank,

It is not prefect but it is nearly there.

You have to Seletec the dat and the Product or Products your Interested in.

Mark

Re: Compare data with previous data

f1234567 — Tue, 24 Apr 2018 10:36:04 GMT

I checked your qvw. It's perfect! Many thanks.

Re: Compare data with previous data

f1234567 — Tue, 24 Apr 2018 11:26:14 GMT

Thanks, Mark! Good idea.

( Though it seems it is a bit too complicated for me 😉 )