Value of an Ageing Bucket in a text box

[alkesh_sharma]

Hello All,

I want Value of ageing buckets in a text box, My expression is

=IF(Today() - [Due Date] < 0, Sum(Value))

The problem here is due date is different for every invoice number and therefore qlikview cannot calculate this in a text box.

Need help Guys.

[alexandros17]

You have given the answer ... to use that expression you have to fix due date for example with a max([DUe Date])

[alkesh_sharma]

But that will not be logical, Every invoice number would have a different Due Date and according to that due date it needs to fall into a bucket, If I take Max of Due Date, everything would eventually fall into one bucket only.

[MK_QSL · Accepted solution]

=SUM(IF(Today() - [Due Date] < 0, Value))

[alexandros17]

You're right and that's the reason for which it is not possible to use a text box to display only one information related to more lines ... you can use the text box if you want the info of a selected line

[jagan]

Hi,

Use Aggr() to calculate by Invoice level

=Sum(Aggr(IF(Today() - [Due Date] < 0, Sum(Value)), Invoice))

Replace Invoice with your actual Invoice field name.

Hope this helps you.

Regards,

jagan.

[alkesh_sharma]

Thanx Manish