Set Analysis problem

Wed, 25 Jan 2012 14:51:59 GMT

I am having two problems with the following expression:

If(([CUSTOMERLEDGERENTRY Due Date]<=vToday) AND ((vToday - [CUSTOMERLEDGERENTRY Due Date])<30),sum({<[DETCUSTOMERLEDGERENTRY Posting Date]={"<=$(=max([DETCUSTOMERLEDGERENTRY Posting Date]))"}>}[DETCUSTOMERLEDGERENTRY Amount]))

My situation is this: I have the sum of amount in a straight table for everything below a selected DETCUSTOMERLEDGERENTRY Posting Date. This works fine.

Next to it I have 4 columns, showing the totals with a due date which has not passed, them with less then 30 days overdue, 90 and more then 90. I have used the expression above to solve this (as an example this shows the one between today and less then 30).

My first problem is: I would like to replace the vToday with the selected DETCUSTOMERLEDGERENTRY Posting Date. But this doesn't work as expected.

My second problem is: When I select a DETCUSTOMERLEDGERENTRY Posting Date with the expression as it is now, he only sums the records with DETCUSTOMERLEDGERENTRY Posting Date at that date and not the ones below.

I have been trying to fix this but can't seem to solve it.

If you need more information don't hesitate to ask.

Regards

Niels

topic Set Analysis problem in QlikView

Set Analysis problem