to capture movements in data between different dates

mohdazhr — Tue, 02 Apr 2019 22:48:23 GMT

Hi all ,

I have got the similar data and multiple iterations of this across several dates. What i would like to capture is the movement for ID's between 2 different dates (allow the user to select the variability of comparison dates like 4 weeks , 12 weeks etc ) and categorise them under

positive movement

negative movement

no Movement

as an example i have the following data

date	id	status
02/04/2015	a1	01
03/04/2015	a1	02
02/04/2015	a2	02
03/04/2015	a2	01
02/04/2015	a3	01
03/04/2015	a3	01

I would like to show is when the user selects Positive movement

id	current status	Last week status
a1	02	01

when user select negative movement

id	current status	Last week status
a2	01	02

when user selects no movement

id	current status	Last week status
a3	01	01

Re: to capture movements in data between different dates

lindelanifakude — Wed, 06 Sep 2023 19:03:51 GMT

@mohdazhr did you find the solution for your post, I'm looking a solution something similar to this?

topic to capture movements in data between different dates in QlikView

to capture movements in data between different dates

Re: to capture movements in data between different dates