If function and match function for 2 inputs?

[ericheleine]

hi everybody,

I have got several input and i want to create a IF function when several dimensions are equal.

excel explanation:

when different order id (column A) have the same Trade date (B), Heure(C), Bank(F) , trader(G) ,Portfolio( H)

and that the column E (Side) is different

calculate the min Amount traded of both (column I)

The result in Qlikview should be in this case 20273793.09

regards

Eric

[Agis-Kalogiannis]

Hi Eric

Can you please try the following expression and tell me if it works?

aggr(min([Abs (NominalEuro)]), [Trade Date], [Heure Exec], Bank, Trader, Portfolio)

Thanks

Agis

ALK

[ericheleine]

thank you agis

i needto use an if function because in the case of the dimension below are different i need to calculate sum(abs(nominal euro))

regards

eric