linking two bar charts

Tue, 24 Aug 2010 15:40:26 GMT

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

linking two bar charts

Tue, 24 Aug 2010 15:58:15 GMT

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.

linking two bar charts

Tue, 24 Aug 2010 16:12:24 GMT

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?

linking two bar charts

Tue, 24 Aug 2010 16:19:32 GMT

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

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

topic linking two bar charts in QlikView

linking two bar charts

linking two bar charts

linking two bar charts

linking two bar charts