15 Replies Latest reply: Nov 9, 2017 2:32 PM by shashanka Chhanda RSS

    Qliksense Join Issue

    shashanka Chhanda

      Hi Team ,

       

      I am trying to join 3 table  i have extract data from my sql

      Its taking so much time not getting the result .

      Please find the code below.

      Please help how to reduce less time

      code:

       

      select

      a.Month as DateField,

      a.Engagement_Code,

      a.Project_Name,

      c.resource_display_name,

          a.Project_StartDate,

          a.Project_EndDate,

        a.Project_Code,

          a.Contract_Type,

          a.Project_Manager,

          a.Project_Work_Location_State,

          a.Payment_Terms,

          a.Project_Stage,

          a.System_Revenue_Recognized,

          a.Consolidated_All_Resource_Direct_Cost,

          a.Consolidated_Other_Direct_Cost,

          a.System_Revenue,

          a.Plan_Utilization_Basis_Hours,

          a.Actual_Utilized_Hours,

          a.Actual_Projected,

          b.Engagement_Name,

        b.Engagement_Account_Executive,

          b.Client_Name

        

         From mis_automation_db.project_details_ppm  a

      Inner  join mis_automation_db.engagement_project_summary_ppm b

      on a.Engagement_Code = b.Engagement_Code

      Inner join  mis_automation_db.project_resource_details_ppm c

        on a.Project_Code=c.Project_Code;