Skip to main content
Announcements
Do More with Qlik - Qlik Cloud Analytics Recap and Getting Started, June 19: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
AT2023
Contributor
Contributor

Sum of value between the two dates, dates are in other table in two Column

Hi  I am calling two tables from two different data sources. they are connected with Key name date. I cannot get the sum of sales between the start date & End date(Refer 3rd Table as a sample) . Plz help me out 

Table 1 (Table from MySQL)

Date Sales
1/1/2023 345
1/2/2023 675
1/3/2023 34
1/4/2023 45

 

Table 2 (Table from SQL)

Date Start Date EndDate
1/2/2023 1/2/2023 1/4/2023
1/3/2023 1/3/2023 1/4/2023

 

I need output like this 

Table 2

Date Start Date EndDate sum sales between the start date & End date  
1/2/2023 1/2/2023 1/4/2023 754
1/3/2023 1/3/2023 1/4/2023 79

 

0 Replies