topic Count total number of people who were not able to use app for more than a given number of days in QlikView

Count total number of people who were not able to use app for more than a given number of days

Wed, 04 Apr 2012 06:18:57 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]))

As per image below, my goal is to show 7624 to the active user field that I created

Re: Count total number of people who were not able to use app for more than a given number of days

Tue, 10 Apr 2012 14:53:27 GMT

Hi,

What's your background data structure like? Do you have a table of distinct user names and session logs etc? Can you attach a copy of your app? I think I would look at breaking it down into more than one step so you could look at counting the number of active sessions in the script perhaps. I'd need to see the file to have a better go at it ... quite difficult with no view of the data structure.

Also ... are you expecting consecutive login over 15 calendar days or working days?

Cheers,

Emma

Re: Count total number of people who were not able to use app for more than a given number of days

CELAMBARASAN — Tue, 10 Apr 2012 15:04:56 GMT

Hi,

Check with this

=Sum(Aggr(if({(today()-date(DataPullDate))<=15},1),LoginName))

=Count({<LoginName={"=(today()-date(DataPullDate))<=15"}>} LoginName)

Celambarasan

Count total number of people who were not able to use app for more than a given number of days

Tue, 17 Apr 2012 04:42:00 GMT

Hi All!

Sorry for the late reply... I was on leave

I can't attach the file so I made a new post and the link is http://community.qlik.com/message/210784#210784