Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Opening and Closing Balances

Hi - I hope someone can help me with this (I think) simple request.

I have some data organised as per the attached file and I need to dynamically calculate the opening and closing balance depending on the month(s) selected.

So for example if no selection was made I would want to return the value for opening balance for the earliest week in the data - 10

If February 18 was selected I would want to return the opening balance for the earliest week in Feb (5/2/18) - 9

Thanks!

0 Replies