topic Re: Opening Amount in QlikView

Opening Amount

Frank_Hartmann — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

i try to show Opening Amount over a period of four months.

however only the second month (Feb) shows the correct values for Opening .

Mar and Apr are showing 0.

How to get the TOTAL Values of the above months Description into the Opening Field ?

And how to get the correct Value for TOTAL in Feb, Mar, Apr?

sunny_talwar — Fri, 06 Oct 2017 12:39:48 GMT

May be this

If(sum(Opening)=0,

Sum(Aggr(Above(Sum(Opening) + Sum(Contributions1) + Sum(Contributions2)), Description, Date)), Sum(Opening))

sunny_talwar — Fri, 06 Oct 2017 12:44:56 GMT

But shouldn't the total change based on the new opening and then the opening for the subsequent month should also change?

Frank_Hartmann — Fri, 06 Oct 2017 12:47:58 GMT

Yes exactly! The Opening is now correct but

the TOTAL should always consider the new Opening Amount!

sunny_talwar — Fri, 06 Oct 2017 12:55:10 GMT

Use this for Total....

Column(1) + Column(2) + Column(3)

But since the total changed, would you not want the Opening to be based on new Total

Frank_Hartmann — Fri, 06 Oct 2017 12:57:48 GMT

Exactly , thats the problem 🙂

sunny_talwar — Fri, 06 Oct 2017 13:01:43 GMT

Check this out

if(sum(Opening)=0,

Sum(Aggr(RangeSum(Above(Sum(Opening) + Sum(Contributions1) + Sum(Contributions2), 1, RowNo())), Description, Date)), Sum(Opening))

Frank_Hartmann — Fri, 06 Oct 2017 13:06:37 GMT

thank you so much sunny

sunny_talwar — Fri, 06 Oct 2017 13:10:36 GMT

No problem at all... I am glad I was able to help