3 Replies Latest reply: Aug 24, 2010 12:19 PM by Nick Borunov RSS

    linking two bar charts

       

      [View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/674/3683.bar-chart.doc:550:0]

      I have got two charts above and I am wanting to combine the two charts so the top chart with project_ID and I am wanting to drill down to a one Project_ID which is done but I know want it to drill down to Part_description. Any suggestions?

       

      OverviewProjects:

      LOAD

      PROJECT_ID,

      NAME,

      DESCRIPTION,

      COMPANY,

      MANAGER,

      STATE,

      CALENDAR_ID,

      CUSTOMER_NO,

      CUSTOMER_PROJECT_ID,

      PLAN_START,

      PLAN_FINISH,

      ACTUAL_START,

      ACTUAL_FINISH,

      APPROVED_DATE,

      CLOSE_DATE,

      CANCEL_DATE,

      FROZEN_DATE,

      DATE_MODIFIED,

      MODIFIED_BY,

      PLANNED_REVENUE,

      ACTUAL_REVENUE

      FROM

      [$(FolderPath)\Live QVD Files\Overview_Project.qvd]

      (qvd)

      WHERE PROJECT_ID = 'S07050720' OR PROJECT_ID = 'S07050721';

       

      OverViewShopOrders:

      LOAD SHOP_ORD_NO,

      PART_NO,

      PART_DESCRIPTION,

      PROJECT_DESCRIPTION,

      PROJECT_ID,

      SUB_PROJECT_ID,

      CONTRACT,

      REVISION_NO,

      STRUCTURE_ALTERNATIVE,

      ROUTING_REVISION,

      ROUTING_ALTERNATIVE,

      LOT_BATCH_NO,

      CONDITION_CODE,

      CLOSE_CODE,

      CLOSE_DATE,

      CLOSE_TOLERANCE,

      PHASE_OUT_DATE,

      CUSTOMER_ORDER_NO,

      CUSTOMER_LINE_NO,

      CUSTOMER_REL_NO,

      QTY_QA,

      QTY_REJECTED,

      OPERATION_SCRAPPED,

      LAST_ACTIVITY_DATE,

      QA_SCRAPPED,

      PLANNER,

      PRE_ACCOUNTING_ID,

      SO_MATERIAL_SUMMARY_STATUS,

      OPERATION_STATUS,

      PRODUCT_STATUS,

      ACTIVITY_SEQ

      FROM

      [$(FolderPath)\Live QVD Files\Overview_Shop_Order.qvd]

      (qvd)

      WHERE PROJECT_ID = 'S07050720' OR PROJECT_ID = 'S07050721';