1 Reply Latest reply: Jun 7, 2018 5:59 AM by Olivier GAUTIER

# How to calculate Active Users (static and trend) on Qlik Sense?

Hello Qlik Sense community!

I am currently working with a mobile payments startup and I was wandering how to calculate static (%) and dynamic (trend) active users (monthly, weekly, daily) on Qlik Sense. The idea is to plot them in a KPI (static) and in a chart (dynamic) Qlik Sense element.

The calculation I wanna make is the following: e.g. MAU=(active users in month X) / (total number of users up to month X)

What I have not figured out so far is:

A) how to tell Qlik Sense to say a user is "active" if she has recharged/paid/etc. at least once in the relevant period

B) how to tell Qlik Sense to count total users up to a specific day

C) how to tell Qlik Sense to count the active users in the last 7 or 30 days (given the flag at point A)

Thank you very much in advance for you help!

Best,

Francesco

• ###### Re: How to calculate Active Users (static and trend) on Qlik Sense?

Hi,

we havn't you data model,

but you can use P() function in your set analysis :

count( Distinct {\$<Customer = P({1<idrecharged={‘*’}>} ) +  P({1<Idpaid={‘*’}>} ) >} Customer )

( = customer whixh have a link with reacharged or paid data)

add you conditions for dates, or not if it is in dimension

regards

• ###### Re: How to calculate Active Users (static and trend) on Qlik Sense?

Hi Oliver,

thank you for your reply! It's useful and right.

Yet, the P function seems to work with one condition only. If I use "+" or "and" to add another condition, Qlik tells me the formula contains an error I cannot find.

Could you help me also with that please?

Thank you again!

Br,

Francesco

• ###### Re: How to calculate Active Users (static and trend) on Qlik Sense?

Hi Francesco,

it should work,

what is your set analysis and error message ?

• ###### Re: How to calculate Active Users (static and trend) on Qlik Sense?

Have you looked at the license monitor app to see if that gives you what you want?  Or you can look at the script it uses to see if you can take out parts that you need.