Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

francescoerriqu
New Contributor

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

Tags (2)
4 Replies
ogautier62
Valued Contributor II

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

francescoerriqu
New Contributor

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

rittermd
Honored Contributor

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.

ogautier62
Valued Contributor II

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 ?