How using If for 2 input identical

[ericheleine]

Hi every body

I have got several input and i want to create a IF function:

if ( "Hours" and "trader" and "portfolio") are the same

And if ("Side" is opposite)

calculate min( Amount order1; Amount order2)

thank you for your help

eric

[#2]

hi

if(Hours = trader and trader =portfolio and portfolio  <> Side,

     min( Amount order1),

     min( Amount order2)

)

[jsingh71]

Please share some sample data so it will easy to write the correct expression.

[ericheleine]

thank you jsingh71 for your quick answer.

i added a excel sheet to go in depth of my issue.

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

[ericheleine]

thank you,

i added a excel sheet to go in depth of my issue.

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