topic customized partial sum! is this possible in QlikView

customized partial sum! is this possible

ali_hijazi — Mon, 26 Sep 2011 11:58:09 GMT

I have a pivot table for the balance sheet with 5 dimensions and expression to display debit - credit amount

for some accounts I'm multiplying the sum(debit-credit) by -1; based on client's request

so suppose under dimensionality 2 I got two partial sums

now for dimensionality 1 the partial sum should be the difference in partial sums of dimensionality 2

is this possible?

Anonymous — Mon, 26 Sep 2011 13:45:32 GMT

Hi there,

I am pretty sure it is possible. But I am not sure how you want to display it.

Do you want have in one expression? Or do you want multiple coloms?

Can you maybe upload an example or screenshot of how you want the result to be shown?

Dennis.