6 Replies Latest reply: Feb 20, 2015 4:53 AM by Łukasz Liziniewicz RSS

    Sum over the period, sum if

    Łukasz Liziniewicz

      Hi QV experts,

      I have one case to solve. My figures describe  invoices of once company. So I have:

      • invoice number,
      • amount,
      • date of invoice,
      • due date (the date that payment should be done)
      • the settlement date of the invoice (the real closing date of the invoice) can be null (if not payed yet) or before after or equal the due date.

      I need to provide the sum of receivables over the period divided into overdue and term receivables (not required on certain day).

      In xls it is something like below.

      Any ideas how to do this in qlickview?