Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikhans
Creator
Creator

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?

0 Replies