Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis problem

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

0 Replies