Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
[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';
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.
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?
First of all - read the Help for Hierarchic groups (drill-down)
You can create a group here: Settings -> Document Properties -> Groups -> New button