How to create bar and line graph based on two data sources?

Tue, 16 Sep 2014 18:15:15 GMT

Hello,

I am trying to create a bar and line combo graph, but I cannot get it to work. I have two data sources that I am in essence trying to include on the graph.

The graph's X-axis should show the MonthName and the Y-Axis should be the Count of events. The Bar Graph should show the number of Diabetic Patient Visits [i.e., (If(Diab_Dx = 'Diabetes',1,0)) ] and the Line Graph should show the number of COMPLETED tests [i.e., (If(Order_Status = 'Completed',1,0)) ]. Diab_Dx comes from one data source and Order_Status comes from a completely different data source. I simply loaded both Files onto this QlikView document (not sure if I did this correctly).

Thanks in advance for any help.

The load script is:

POC_Results_Data:
LOAD

*,
Order_Date,
    Year(Order_Date) AS Ord_Year,

      MonthName(Order_Date) AS Ord_Month,

      Day(Order_Date) AS Ord_Day,

FROM

POC_Results_Data.qvd

(qvd);

Patient_Visits:

LOAD *

     Year(Visit_Date) AS Visit_Year,

      MonthName(Visit_Date) AS Visit_Month,

      Day(Visit_Date) AS Visit_Day,

     if(WildMatch(Enc_Dx, '*Diabet*'), 'Diabetes',

      if(WildMatch(Enc_Dx, '*'), 'Non-Diabetes',)) AS Diab_Dx

     FROM

(qvd);

Re: How to create bar and line graph based on two data sources?

maxgro — Tue, 16 Sep 2014 18:24:42 GMT

try to associate the 2 tables by date (= year, month, day); in the second load change visit to ord

Year(Visit_Date) AS Ord_Year,
MonthName(Visit_Date) AS Ord_Month,
Day(Visit_Date) AS Ord_Day,

Re: How to create bar and line graph based on two data sources?

Wed, 17 Sep 2014 13:52:01 GMT

Thank you!

topic Re: How to create bar and line graph based on two data sources? in QlikView

How to create bar and line graph based on two data sources?

Re: How to create bar and line graph based on two data sources?

Re: How to create bar and line graph based on two data sources?