Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

How to count a Change of participant in string values

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

4 Replies
MVP
MVP

Re: How to count a Change of participant in string values

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

Not applicable

Re: How to count a Change of participant in string values

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

MVP & Luminary
MVP & Luminary

Re: How to count a Change of participant in string values

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

- Marcus

Not applicable

Re: How to count a Change of participant in string values

Thanks  That is the Correct Answer,