3 Replies Latest reply: Apr 17, 2012 12:42 AM by lorens_edic RSS

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

      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

       

       

       

      QLIK.JPG