topic Re: Overdue in QlikView

Overdue

gautik92 — Wed, 25 Nov 2020 16:16:04 GMT

I want to find Accounts payable Overdue

VendID Amount DueDate

1 100 15-10-2016

2 200 20-12-2016

3 300 25-12-2016

4 100 30-12-2016

i am using this formula

=if(aggr(Today() > DueDate,DueDate),Sum(Amount))

as per this i want to get 300 but getting ( - )any ideas

vinieme12 — Thu, 22 Dec 2016 05:16:37 GMT

It should be like

Sum ( {< Due date = {'<$(=today ())'} >} Amount)

PrashantSangle — Thu, 22 Dec 2016 05:18:46 GMT

Hi,

try,

Sum(if(Today() > DueDate,Amount))

Regards

tamilarasu — Thu, 22 Dec 2016 05:30:43 GMT

Hi Gowtham,

If your date format is set like below then you can use Pujari's solution,

SET DateFormat='DD-MM-YYYY';

Sum ( {< [DueDate] = {'<$(=Today ())'} >} Amount)

If not, you can use

Sum({< [DueDate] = {"<$(=Date(Today(),'DD-MM-YYYY'))"} >} Amount)