# Qlik Sense App Development

MVP

## Re: Qlik sense Balance Sheet

What output do you expect to see now? Would you be able to give me the numerical values when you select 02/03/2018 and numerical values when you select 02/04/2018

New Contributor

## Re: Qlik sense Balance Sheet

Final result for 02/03/2018:

- BTW (A) is now a sum of account number 61000 and 61100

 BTW (A) 6 Cash 10 Vennootschapsbelasting (A) 15 Totaal activa 31 BTW (P) 0 rsz 18 Vennootschapsbelasting (P) 0 Totaal passiva 18

Final result for 02/04/2018:

- Here the BTW (P) has only a booking on account number 61000 so it will display fine just like all the rest who only have 1 account number. As soon as there is a combination of account numbers for a certain heading it won't display

 BTW (A) 0 Cash 2 Vennootschapsbelasting (A) 0 Totaal activa 2 BTW (P) -4 rsz 18 Vennootschapsbelasting (P) -7 Totaal passiva 7

Also: the subtotals "totaal activa" and "totaal passiva" were empty

Highlighted
MVP

## Re: Qlik sense Balance Sheet

Try this

```Sum(
Aggr(
If(Count(TOTAL <Rekening> DISTINCT FlagAPChangeSection) = 1, Sum(Saldo),
If(Sum(TOTAL <Rekening> Saldo) > 0, Sum({<FlagAPChangeSection = {'A'}>} Saldo), Sum({<FlagAPChangeSection = {'P'}>} Saldo)))
, Rekening, FlagAPChangeSection, [Balans Heading Management])
)```
New Contributor

## Re: Qlik sense Balance Sheet

It worked! Wow, thank you so much for your help!!

New Contributor

## Re: Qlik sense Balance Sheet

Hi,

This solution doesn't seem to work for me.  I would like to make a balance sheet i.e. a cumulative amount where I have a pivot table with Reporting Period as a column and Account as a row.  Note, in addition I have a number of other variables in both columns and rows.  The basic functionality should just make a cumulative total across Reporting Period for each of the other variables shown.

e.g. given underlying data of:

Account, Reporting Period, Amount

I would like to show: