linking two bar charts

[#1]

[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';

[#2]

There are two ways to do this:

1) create dril-down group for Project Id and Part-Description fields, and use the same chart with this group as dimension

2) on your detailed chart you can add calculation condition if only one project get selected.

[#3]

I am very new to qlikview and i am still trying to master the basics. in simple steps how would you create a drill down group?

[#4]

First of all - read the Help for Hierarchic groups (drill-down)

You can create a group here: Settings -> Document Properties -> Groups -> New button