running account balance

[#1]

Hello there,

How can the following example in excel be replicated in Qlikview? I have the month and Transaction Columns and I am trying to create the balance column. This is in a pivot table or a straight table. Trying to do this in the front end and not while reading the data in loading script.

Thanks in advance

[#2 · Accepted solution]

Hi,

You can get the balance by using expression "sum(Transaction)" and selecting the "Full Accumulation" option for this expression from chart properties.

Thanks

Amit

[#3]

My accumulation option is greyed out. Why is that?

[#4]

Because you've got pivot table, not straight table.

[#5]

True and correct. Thank you. Unfortunatelly I am missing the data where transaction is zero. That is when there is no transaction in a month, the month is missing. Also when selecting a month with no transactions no balance is shown. What I need is exactly how it is shown in the excel picture if possible.

Thanks again.

[#6]

Got everything to work as I needed. I had a copy of another straight table, and it had some flags altered. After I changed the suppress zero values, it worked. Thanks again