How to extract a list based on changes in a field

[Anonymous]

Hi,

I would like to extract a list of customers who have changed a field (Mode) from a specific value (T1) to another (A2) in a selected period.

I attached sample data and the qvw.

Thanks!

E.

[sunny_talwar]

If the change is only going to be from T1 to A2 and never the other way, you can try this as your set analysis in the chart

{<CUSTOMER = {"=Count(DISTINCT {<MODE = {'A2', 'T1'}>}MODE) = 2"}>}

[sunny_talwar]

Question:

When Selecting 2016 and 02, I don't see T1 for either A and B. Why would we see A and B?

[Anonymous]

Thank you for these answers.

I want to display them because in the selected month they have A2 and, in their past, the previous Mode was T1.

Instead, in 2015 12 (and all other previous month) nobody has A2 as current Mode.

I think I must use Validity Dates of records, but I can't find the corret expression.

Thanks a lot for your interest.

E.

[Anonymous]

I solved my problem, thanks.

E.