5 Replies Latest reply: Apr 19, 2012 5:24 AM by Dennis Hoogenboom RSS

    Count Total Number of Active Users

      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.

       

      Capture.JPG