3 Replies Latest reply: Dec 22, 2016 6:10 AM by Matthias Walter RSS

    Working with different Calendars and Tables

    Matthias Walter

      Hello everybody,

       

      I'm new to Qlik Sense and having problems. I currently have 2 Tables I'm working with, which are generated Reports so I can't change them much outside of Qlik Sense.

      The Tables look like this:

       

      Table 1:

      TaskDatePersonDuration (hrs)
      01.04.2016Person11

      01.04.2016

      Person22
      01.04.2016Person13
      05.05.2016Person14
      10.05.2016Person25

       

      Table 2:

      PersonSalaryDateSalary
      Person101.04.20161000
      Person201.04.20161000
      Person101.05.20161500
      Person201.05.2016500

       

      My goal is to get a Table looking like this:

      Personsum(Duration)sum(Salary)

       

      So far no Problem. The Problem is to filter for Dates. I can't get a link between "TaskDate" and "SalaryDate", so when I want to filter for April I want to get this:

      Personsum(Duration)sum(Salary)
      Person141000
      Person221000

       

      But with a Filter on "TaskDate" I get this:

      Personsum(Duration)sum(Salary)
      Person142500
      Person221500

       

      I hope you understand what I mean. iI think the problem is, that the Tables are only linked via "Person" and that they have  n:m relations.

      I tried this approach: Tutorial - Using Common Date Dimensions and Shared Calendars but it didn't work (I think because there are no 1:1 relations..)

       

      Do you have an Idea how to deal with this issue?