How to count a Change of participant in string values

[#1]

How to count a Change of participant in string values,

when a participant make a change in a population group, jump from group A to Group B, Group B to C, and D to A. Its 3 changes.

Count({<?????????????>} Distinct[Number of Participants] or [Population Group]

Number of Participants

Population Group A

Population Group B

Population Group C

Population Group D

Please explore your brain for this New to Qlik sense

Thanks in Advance

[swuehl]

Can you post some sample records? It's not clear to me how your data look like.

[#3]

Month   Aug

Year    2016

Participant ID    11111

Population Group Name      ABC     DEF    GDI    MNO   XYZ

Population Group Code  1  2   3  4   5

If Anything else please let me know, all I want to capture or sum  the change when somebody do it from one group from other. or I need to create a column in data script, Any help will be appreciated.

Thanks

[marcus_sommer]

I think you need something like this: Slowly Changing Dimensions.

- Marcus

[#5]

Thanks  That is the Correct Answer,