4 Replies Latest reply: Jun 25, 2015 8:34 AM by Eric HELEINE

# How using If for 2 input identical

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)

eric

• ###### Re: How using If for 2 input identical

hi

min( Amount order1),

min( Amount order2)

)

• ###### Re: How using If for 2 input identical

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

• ###### Re: How using If for 2 input identical

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

• ###### Re: How using If for 2 input identical

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