Compare data with previous data

[f1234567]

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!

[Anil_Babu_Samineni · Accepted solution]

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

[f1234567]

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

[Mark_Little]

! !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

[f1234567]

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

[f1234567]

Thanks, Mark! Good idea.

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