topic Re: Sum of sales within date range in QlikView

Sum of sales within date range

jorgen_santberg — Tue, 09 Oct 2018 15:03:29 GMT

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!

Re: Sum of sales within date range

vishsaggi — Tue, 09 Oct 2018 15:15:34 GMT

May be you want interval match check here:

Intervalmatch example – with dates

Re: Sum of sales within date range

jorgen_santberg — Wed, 10 Oct 2018 07:39:26 GMT

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!