Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Cohort Analysis & Churn in Qlikview

Hi i´m facing a Problem:

Let´s say i have following Data:

EventDate
SignUpDateUserIdCountSessions
01.01.201501.01.201511
01.01.201501.01.201521
02.01.201501.01.201511
03.01.201501.01.201521
............

with a lot more users and entries in a bigger timerange

what i´m trying to achieve is a cohort analysis, to check for every month if a user has still entries for "CountSessions"

So the Result should be like:

TimeRange

Jan-2015

Count(UserId with "CountSessions")

Feb-2015

Count(UserId with "CountSessions")

Mar-2015

Count(UserId with "CountSessions")

Apr-2015

Count(UserId with "CountSessions")

Jan-2015 SignUp Users500450300250
Feb-2015 SignUp Users-550450380
Mar-2015 SignUp Users--350300
...............

So I want to have a Chart where i can See for a given Timerange how many Users, who signed up in a given Month (e.g. Jan-2015 = 500) and how many Users of these have still Session Entries in the following Months.

So for this example the Result is: 50% of the Users who signed in Jan-2015 are still active in April-2015 (250 User/500 User).

I hope somebody can help me

Cheers

Steve

10 Replies
dhavalvyas
Contributor III
Contributor III

HI Sergey can you help me out please..as I m trying cohort analysis from lsat one months..

Thanks in Advanced