topic Re: Calculate total amount in QlikView

Calculate total amount

Wed, 25 Nov 2020 16:16:04 GMT

Hello, everyone.

I have the following table:

- DETAIL LEVEL 8 accounts have values in the table. Because of that, I can SUM(Amount) and get the desired amount (100, 150, 50...).

- DETAIL LEVEL 7 accounts DO NOT have values in the table. For these, what I want to do is to get the total from the sum of its level 8 accounts. For instance, for the first row, 2641.51111 = 2641.51111.1 + 2641.51111.2 + 2641.51111.3 = 100 + 150 + 50 = 300. Thus, I would like the first row to totalize 300. In the very same way I would want 2641.51112 to sum 200 + 800 = 1000.

Can this be achieved?

Thank you very much.

Re: Calculate total amount

sunny_talwar — Mon, 23 Jan 2017 13:08:29 GMT

May be like this:

If([DETAIL LEVEL] = 8, Sum(Amount), Sum(TOTAL <[BUSINESS UNIT], [OBJECT ACCOUNT]> Amount))

Re: Calculate total amount

Mon, 23 Jan 2017 13:21:52 GMT

I love you. It is indeed, Sunny T.

I thank you immensly.

Re: Calculate total amount

sunny_talwar — Tue, 24 Jan 2017 00:39:42 GMT