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: 
jorgen_santberg
Contributor III
Contributor III

Sum of sales within date range

Hi all,

I am trying to get the number of sales sold in a promotion period to a specific customer. The salesdate and calendar have the field time, while the promocalendar has a startdate and an enddate.

If I select the month August for example, I want to see all the promotions per customer that started or ended in that specific month and the volume sold between the startdate and enddate of the promotion.

The fields of my salesdata are:

- customer

- sales

- time

- article

The field of my promotiontable are:

- startdate

- enddate

- customer

- article

- promotion # (= Rowno())

Help would be very much appreciated!

2 Replies
vishsaggi
Champion III
Champion III

May be you want interval match check here:

Intervalmatch example – with dates

jorgen_santberg
Contributor III
Contributor III
Author

Hi yes this partly solves it, thanks! The only challenge I have now is that I have to create all possible combinations between Customer, Time and Article from a date in the past to a date in the future (because otherwise I can not see the promotions planned in the future). I will check the forum for the solution, but any help in the meantime would be great!