topic Count Total Number of Active Users in QlikView

Count Total Number of Active Users

Tue, 17 Apr 2012 02:02:01 GMT

Hi All,

I am trying to count the number of active users who are able to use mobile email service.

My criteria of an active users is that they should have consecutive log in for 15 days.

These are the possible formula that I created as a variable which didn't work

=if({(today()-date(DataPullDate))<=15},count(LoginName))

= count ( distinct(if (today() - date([Last Success Sync])<90),[LoginName]))

From the past thread that I have, I was given a formula =Count({<LoginName={"=(today()-date(DataPullDate))<=15"}>} LoginName) but it is not showing the correct numbers of active users who logged in for 15 days.

Moreover, I am using QlikView 11 but our server is using qlikview 10 so in my straight table, the settings that I have indicated in the Dimension Limits to show records that are greater or equal to 90 is not working. I think the problem is here that the settings in version 11 is not supported by our server which is currently in version 10.

Count Total Number of Active Users

hallquist_nate — Tue, 17 Apr 2012 16:35:15 GMT

I think to fix your first formula, it should look like this:

=if((today()-date(DataPullDate))<=15,count(distinct LoginName))

As for Using QV11 with Server 10, yeah, that is a problem. You should upgrade to Server11, or you could try a conditional calculation, or conditional sort. You'd have to play around with it.

Count Total Number of Active Users

v_iyyappan — Tue, 17 Apr 2012 17:04:55 GMT

Hi,

Use like below expression

= if((Num(today())-Num(DataPullDate))<=15},count(LoginName))

= if((Num(today())-Num([Last Success Sync]))<=90},count(Distinct LoginName))

Regards,

Iyyappan

Count Total Number of Active Users

Thu, 19 Apr 2012 00:43:13 GMT

It Iyyappan V, it didn't work Moreover, I observed you used a close bracket but there is no open bracket in your formula, are trying to establish a set expression? If yes, I put the open bracket as shown below, but still didn't work...

= if({(Num(today())-Num(DataPullDate))<=15},count(LoginName))

= if({(Num(today())-Num([Last Success Sync]))<=90},count(Distinct LoginName))

Count Total Number of Active Users

Thu, 19 Apr 2012 00:45:34 GMT

Hi Nate,

I tried that formula before but it didn't give me any values...

Count Total Number of Active Users

Anonymous — Thu, 19 Apr 2012 09:24:06 GMT

Have you tried to make a flag in your loading script?

What you could do is something like:

Load ....

LoginName,

LastSuccessSync,

IF (LEFT((NUM(Today())),5)-LEFT(NUM(MAX(LastSuccessSync)),5) < 15 , 1) as CountActive.

...

From ...

I think this way you could use : Sum(CountActive)

Good Luck,

Dennis.