Date1 and Date2 in one chart

[wunderch]

Hi,

I have the following problem:

I have a table with 2 dates and a table with date and sales.

Now I want a chart with Date1, Sales and Date2, Sales.

Something like this:

Date1	Sales	Date2	Sales
01.03.2017	5	02.03.2016	10
02.03.2017	10	03.03.2016	20
03.03.2017	15	04.03.2016	30
04.03.2017	20	05.03.2016	40
05.03.2017	25	06.03.2016	50
06.03.2017	30	07.03.2016	60
07.03.2017	35	08.03.2016	70
08.03.2017	40	09.03.2016	80
09.03.2017	45	10.03.2016	90
10.03.2017	50	11.03.2016	100

Header 1

Look at my example.qvw.

Can anyone help me????

Thanks

[Anil_Babu_Samineni]

Like this?

[wunderch]

Yes. That's what I need.

How can I get this without loading my Sales-Table twice??

[Anil_Babu_Samineni]

I assume, You have Date1, Date2, Sales in Single Table. can you check my file once. if not, Please share sample excel file to look the same

[wunderch]

Look at my example Date1 and Date2.qvw and the xlsx.