topic Re: How to extract a list based on changes in a field in QlikView

How to extract a list based on changes in a field

Anonymous — Thu, 04 Feb 2016 09:40:06 GMT

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!

sunny_talwar — Thu, 04 Feb 2016 09:47:20 GMT

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 — Thu, 04 Feb 2016 09:49:53 GMT

Question:

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

Anonymous — Thu, 04 Feb 2016 10:04:07 GMT

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.

Anonymous — Thu, 04 Feb 2016 16:10:48 GMT

I solved my problem, thanks.