4 Replies Latest reply: Aug 3, 2016 3:42 AM by Srijhari Katragadda RSS

    Comparing categorical fields in two different tables

    Srijhari Katragadda

      HI,

       

      I have one table with a list of all users using an app. Another dynamically generated column in a straight table that generates a list of users who have used the app in the recent past based on Date, Minute, Week, Hour etc.

       

      I need to create another field that shows all the users who are NOT using that app even if they have access. I want to do something like ALL USERS - Users logged in = Users not logged in.

       

      Also, I want to see these results based on the filters, i.e Date, Month, Hour etc.

       

      How can I do this in Qlik Sense?

       

      Please help!

       

      Thanks,

       

      Srijhari