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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Retrieve open invoice amount from selected date (master Cal.)

I have a table which contains two dates, a duedate and a payment date and an invoice amount.

My client wants to know the open invoice amount on a specified date or a period .

I want to now how i can accomplish this ?

I've created a master calendar so the client can pick any date he wants.

How can i connect these dates so that we can see the open invoice amount on that date or period .

See the table

With regards,

Ron 

2 Replies
MK_QSL
MVP
MVP

are all these invoices paid?

If yes, please provide some data with unpaid invoices also.

Not applicable
Author

Yes, all paid. We want to know at any given day, what was the open amount

Ron