stacked graph using 2 tables

[Anonymous]

Hi.

not sure why this isn't working, but i am loading data from 2 QVD files, incident and request data. I want to count the ticket status of both incident and request tickets in one chart, a stacked bar chart.

Problem is, its putting the request tickets in a bar of its own, whilst counting the incident status.

in the screen shot below, you'll see my chart and expressions that i am using. The blue bar is incidents - showing the status, and the red bar is requests - showing separately. I want to see the red on top of the blue, where the status is the same?

i am doing a simple Load statement in my script along the lines of:

Request_Tickets:

Load

FLD_TICKETID as Request_ID,

FLD_REQUESTSTATUS as req_Status,

FLD_REQUESTTYPE

FROM

\\qvtest\QlikView_Files\qvds\final\group\remedy\WO_Request_final.qvd

(qvd)

where not WildMatch([FLD_REQUESTSTATUS],'Withdrawn') and FLD_REQUESTTYPE='123 - Service Request';

incident_data:

Load

FLD_TICKETID,

Status

FROM

\\qvtest\QlikView_Files\qvds\final\group\remedy\OP_Request_final.qvd

(qvd)

where not WildMatch(Status,'Withdrawn');