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