topic Repeat amount for specific dimension in QlikView

Repeat amount for specific dimension

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

I have 2 amounts to calculate that I have to repeat per customer who belongs to Group.

Example :

Customer	Group	Salary mass	Amount 1 (sum per Customer)	Amount 1 (per Group)	Amount 2 (salary mass - Amount 1)
1	A	10 000€	1 000€	700€	9 000€
1	B	10 000€	1 000€	300€	9 000€
2	C	25 000€	12 000€	2 000€	13 000€
2	D	25 000€	12 000€	8 000€	13 000€
2	E	25 000€	12 000€	2 000€	13 000€

I tried with AGGR() or TOTAL function and I didn't manage to get the results of Amount 1 (sum per Customer) and Amount 2 (salary mass - Amount 1)

I will be grateful if you have any solutions for this case.

Thank you !

Re: Repeat amount for specific dimension

sunny_talwar — Thu, 02 Jun 2016 09:31:03 GMT

Try TOTAL qualifer with Customer field name -> TOTAL <Customer>

1) Sum(TOTAL <Customer> [Amount 1])

2) Sum([Amount 1])

3) Only([Salary mass]) - Sum(TOTAL <Customer> [Amount 1])

Re: Repeat amount for specific dimension

l_denivelle — Thu, 02 Jun 2016 09:49:59 GMT

Cool ! it works. I didn't know I could use TOTAL function like this.

Thank you