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

      TableA.Actuals

      TableB.Forecast

       

      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!