Discussion Board for collaboration on QlikView Scripting.
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
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?