topic Re: Churn Rate Expression in QlikView

Churn Rate Expression

Tue, 02 Apr 2013 07:22:21 GMT

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 )

Re: Churn Rate Expression

sushil353 — Tue, 02 Apr 2013 07:25:24 GMT

use relative option in Expression tab...

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

HTH

Sushil

Re: Churn Rate Expression

Tue, 02 Apr 2013 07:48:59 GMT

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... ??

Re: Churn Rate Expression

sushil353 — Tue, 02 Apr 2013 08:56:48 GMT

you can use set analysis for that..

you can post the sample data to give us clear understanding