Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
mohdazhr
New Contributor

to capture movements in data between different dates

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

dateidstatus
02/04/2015a101
03/04/2015a102
02/04/2015a202
03/04/2015a201
02/04/2015a301
03/04/2015a301

 

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

id current status Last week status
a10201

 

when user select negative movement 

id current status Last week status
a201

02

 

when user selects no movement

id current status Last week status
a30101