Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try this:
Sum(TOTAL <Cust_id> claimamount)
Try this
Aggr(sum(claimamount),Cust_id,Membername)
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