How to create bar and line graph based on two data sources?
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).