Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Churn Rate Expression

Hi fellows )  I need to find some % the relation of the active audience in this temporal interval to registered in previous (for example if in a week 1 at us 100 users registered, and in a week 2 from them came 20, churn rate will be 20%).

So i has the next fields: "login_user_id" and "reg_date" it's User ID and Timestamp of his registration. And i thought that active audience this is the users who having registered 1 time within a week came into game at least. And i can't understand how to build right expression.

Thnx! I hope for the help )

1 Solution

Accepted Solutions
sushil353
Honored Contributor II

Re: Churn Rate Expression

you can use set analysis for that..

you can post the sample data to give us clear understanding

3 Replies
sushil353
Honored Contributor II

Re: Churn Rate Expression

use relative option in Expression tab...

if this not works then please explain your requirement and post sample app.

HTH

Sushil

Not applicable

Re: Churn Rate Expression

Yes but i need some logic to expression build. How to get active user data and take the data of registered users in previous period and make some differense between them... ??

sushil353
Honored Contributor II

Re: Churn Rate Expression

you can use set analysis for that..

you can post the sample data to give us clear understanding

Community Browser