4 Replies Latest reply: Aug 23, 2016 1:00 PM by Craig Bence RSS

    Connecting two tables from different databases by Month

    Craig Bence

      We are new to Qlik Sense and are trying to find a way to connect two tables (from different databases) on a Month value that differ between the two tables.

       

      Table 1 - Has a "Created On Date" that is a standard date field. We are using the AutoCalendar section for this date (and it works as expected)   (We need to pull monthly Sales $$ from this table)

       

      Table 2 - Has only a field Called "Month" and values like "Apr", "May", Nov", etc. (we need to pull monthly Overtime hours from this table)

       

      Being new to this language, we are struggling to determine a way to Create a Combo chart representing this relationship.

       

      Any coding ideas on how to do this would be greatly appreciated!

       

      Thanks.