Comparison from different period of time

[Anonymous]

Hi everyone,

I am a new user of Qlikview. Basically, To make it simply, I have below table:

Customer ID	Period	Name
A	201801	Paul
A	201801	Peter
A	201802	Paul
A	201802	Peter
A	201803	Mary
A	201803	Susan

My question here, is it possible to make an indicator which showing any changes for the name by period? I want a table like this:

Customer ID	Period	Name	Indicator
A	201803	Paul	Remove
A	201803	Peter	Remove
A	201803	Mary	Add
A	201803	Susan	Add

[uacg0009]

Hi Peter,

yes, order by Period firstly, then Customer ID.

and for the highlight part, it's correct. 201801 has John, 201802 don't have John. So it's correct.

if the answer is correct, please mark as "correct".

Thanks.

Aiolos

[Anonymous]

Hi Aiolos,

Thanks for your reply, maybe I didn't explain it clearly....let says for customer B, what I want to compare is the change when compare to previous period, so if 201802 did not occur, the comparison would be 201803 and 201801, so I want the table showing there is a 'Remove' of John in Period of 201803.

Regards

[uacg0009]

Hi Peter,

I got your point, please see the new version.

Thanks.

Aiolos