9 Replies Latest reply: Nov 3, 2017 11:33 AM by Michael Tarallo RSS

    Join two tables and use one dimension for filtering

    Onur Kocyigit

      Hi everyone,


      i´m new to qlik sense and facing following topic:


      I have two measures, both coming from different tables. After joining the two tables through Year and Month I want to use year and month as filtering dimensions in my report. I have following fields in my report:


      TableA.Year, TableB.Year

      TableA.Month, TableB.Month




      When I use TableA. Year and TableA.Month, the figures from TableB.Forecast are not reacting. Only TableA.Actuals. What do I have to change in order to be able to filter with Year and Month both measures Actuals and Forecast?


      Thank you in advance!