Sumif function in qlikview

[Anonymous]

Dear All,

As mentioned below result i required the same in Qlikview.

Cust_id	Membername	claimamount	SUMIF($A$1:$A$11,A1,$C$1:$C$11)
802219	Kishorbhai Soneji	41682	43364
802228	Sahina Pathan	29673	29673
802545	Ranjanben	6672	6672
802557	Motilal Kanjani	24690	27159
802558	Kala Devi	9643	9643
802581	B Shiva Nayak	14848	14848
802592	K Devi Kumari	33000	33000
802617	Jacob K Thomas	14578	14578
802557	Motilal Kanjani	2469	27159
802219	Kishorbhai Soneji	1682	43364

Thanks in Advance..

Rgrds,

Rafi.

[sunny_talwar]

Try this:

Sum(TOTAL <Cust_id> claimamount)

[avinashelite]

Try this

Aggr(sum(claimamount),Cust_id,Membername)

[agomes1971]

Hi,

please read this

When is it best to use sum(if()) over Set Analy... | Qlik Community

My guess: Aggr(sum(claimamount),Cust_id)

HTH

André Gomes