Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to create opening balance and closing balance

Hi,

I have monthyear, billing extended price, booking extended price and salesperson columns.

I have created closing balance like bookingextendedprice-billingextendedprice = closing balance, but opening balance I am not able to create. Please give me some Idea here, these things I have to create in script. Please find the sample data.

3 Replies
sdmech81
Specialist
Specialist

Hi.

Calculations are based on the business need. I could see only few column in the excel.

Get this requirement from your client/partner. For requirements and what they want only they can help you.

Sachin

jonathandienst

If you have movement only (bookingextendedprice - billingextendedprice), then you cannot compute both the opening AND closing balance. You need one and you can calculate the other, but you cannot compute both from movements only.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable
Author

Hi Jonathan,

I have two column, I thought booking-billing =closingbalance values are the closing balance for  each month, so we can get the peek(closingbalance) as openingbalance. Lastmonth closing balance is the opening balance for the next month. so I thought like that.

Could you please give me some structure how it should be in source table.

Thanks,