Ships vs Returns In the Same Chart

[#1]

Hi,

I need help building a certain chart that has goods shipped vs goods returned based on ship date and return date respectively. I want the chart to have the calendar or fiscal year dates by each day on the X-axis and the quantity on Y axis. I want a bar graph showing the number of returned products based on return date and a line graph showing the number of products shipped based on ship date. I have attached two separate excel sheets, one for ships and one for returns. The products in these charts are not necessarily the same so treat them as two separate spreadsheets. I want both these graphs on the same chart.

I've attached a picture of how the chart should look like along with the excel. I'd really appreciate the help.

Thanks,

Joe

[jose_vargas · Accepted solution]

HI Joe.

First, you have to load the excel into the Qlikview. Then you have to create a chart and select the 3rd one. "combined graphic" In dimension, select the date, and in tab expression you have to create 2 exp, 1 for ship and 1 for return.

If you want more help, load the data in qlikview   .qvw and send for help whit the graphics.

[Anil_Babu_Samineni]

You attached one more image. what is that?

[#4]

Thanks Jose,

I'll try it and let you know. Thanks again, Appreciate the quick response.

[#5]

Hey Anil,

That image shows how I want the chart to look like. It has ships as the line graph and returns as the bar graph.

Thanks,

Joe