topic Re: Ships vs Returns In the Same Chart in QlikView

Ships vs Returns In the Same Chart

Tue, 26 Jul 2016 16:04:38 GMT

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

Re: Ships vs Returns In the Same Chart

jose_vargas — Tue, 26 Jul 2016 16:18:19 GMT

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.

Re: Ships vs Returns In the Same Chart

Anil_Babu_Samineni — Tue, 26 Jul 2016 16:53:41 GMT

You attached one more image. what is that?

Re: Ships vs Returns In the Same Chart

Tue, 26 Jul 2016 17:45:31 GMT

Thanks Jose,

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

Re: Ships vs Returns In the Same Chart

Tue, 26 Jul 2016 17:47:07 GMT

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