topic Re: If function and match function for 2 inputs? in QlikView

If function and match function for 2 inputs?

ericheleine — Thu, 25 Jun 2015 12:43:14 GMT

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 — Fri, 26 Jun 2015 10:54:37 GMT

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 — Fri, 26 Jun 2015 14:44:16 GMT

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