0 Replies Latest reply: Apr 10, 2018 5:35 PM by mattia fravezzi RSS

    Filter data by function into related table

    mattia fravezzi

      Hi all, i'm a novice of qlik sense, I would like to create a new app but I've got some problems with filters.... I need to create a filter like this:

       

      Table User => Table Post

       

      I need to filter NEW users or OLD users by a selected date (selected in another filter).

       

      NEW users are all people that in that selected year had insert their first post.
      OLD users are all people that in that selected year had insert a post, but they had insert a post even in previous years.

       

      in sql table are :


      USER:
      id

      name

       

      POST:

      id
      userId
      insertDate

       

      Have you got any idea?

       

      Thanks

      M.