Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

qlikhans
Contributor

cash collection prognoses

Hi all,

I need to create an overview in which:

1. all payments received in the reporting month are listed in one column

2. expected future payments in monthly columns

Invoicenumberpaid 2018-01 (reporting month)2018-022018-03etcetc

Please see attached file

The reasoning is to allocate a (future) payment to a column by defining an additional date. The logic could be something like

IF(Pay_date<>0 than Pay_date = Payment_Date,

      Elseif(Rep_Date>Due_date than Rep_Date+45= Payment_date ;

           Else (Due_date+15= Payment_date)

How should I do this?