Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
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