Sum under special conditions

[#1]

Hi,

I have the following problem:

I have a table like this:

BorrowerID	AccountID	AccountExposure	LtV
11	1	100	40
12	2	100	60
13	3	200	30
13	4	200	20
13	5	400	60
14	6	50	10
14	7	100	60

Now I want to sum the AccountExposure of all Accounts one Borrower has under the Condition that one of the belonging LtVs is greater than 50.

So in this case the result should be (100+200+200+400+50+100) = 1050 and not (100+400+100) 600.

I hope someone can help me and I am looking forward to it.

Best regards

ThorQlik

[#2]

okay, I want to sum all K2 that belong to the same ID1, if the Max of all to ID1 belonging K3 is bigger than 55.

Moreover the Date should be the 31th of Oktober 2015 and K1 should be bigger than 5.000.000.

The result for the above fourth KPI should be about 96.642.956.

[sunny_talwar · Accepted solution]

Try this:

Sum({<ID1 = {"=Max(K3)>55"}, Date = {"$(=Date(MakeDate(2015, 10, 31), 'DD.MM.YYYY'))"}, K1 = {'>5000000'}>}K2)

[#4]

You are the best. Thank you very much.

Now I have to workout several other conditions, but I know it is possible and hopefully I will get everything done.

[sunny_talwar]

Yup, keep trying and I am sure you will figure it out