Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
matancha
Contributor

Sum Opening Balance Problem

Hi All.

Please take a look at the attached file.

In the original table (Balance) for each account, for each day I have it's opening balance (prev. opening Bal + prev balence).

I'm trying to get in a pivot table, for each account, for any selection, i'ts opening Balance.

(Notice for the timeDisplay cyclic dimension: Year\Year-Month\Year-Week\Date)

i.e - for any account, what i want to get in the total row is -  the opening balance of the minimal day (of the specific account).

Moreover:

1:  I want to show, in another total row the sum of all accounts opening balance.

2: if it's possible to show in the total row, also the closing (opening + Sum(balance)) Balance.

My Problems - For example -

If no selection - no account have opening balance (no transations on 01/01/2012).

If i select May, to account 59 there is no opening balance, Because in this account there is no transactions in 1/5/2012.

How can I do that?

Many many thanks -

Matan

1 Reply
matancha
Contributor

Re: Sum Opening Balance Problem

Somebody?

Maybe start whith:

How can I show the opening balance for each account, and sum all the opening balance?

Community Browser