Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Can you post some sample records? It's not clear to me how your data look like.
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
I think you need something like this: Slowly Changing Dimensions.
- Marcus
Thanks That is the Correct Answer,