Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
wunderch
Creator
Creator

Date1 and Date2 in one chart

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:

 

Date1SalesDate2Sales
01.03.2017502.03.201610
02.03.20171003.03.201620
03.03.20171504.03.201630
04.03.20172005.03.201640
05.03.20172506.03.201650
06.03.20173007.03.201660
07.03.20173508.03.201670
08.03.20174009.03.201680
09.03.20174510.03.201690
10.03.20175011.03.2016100
Header 1

Look at my example.qvw.

Can anyone help me????

Thanks

4 Replies
Anil_Babu_Samineni

Like this?

Capture.PNG

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
wunderch
Creator
Creator
Author

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
wunderch
Creator
Creator
Author

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