topic Re: How using If for 2 input identical in QlikView

How using If for 2 input identical

ericheleine — Thu, 25 Jun 2015 08:27:22 GMT

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

Thu, 25 Jun 2015 08:37:48 GMT

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

min( Amount order1),

min( Amount order2)

)

jsingh71 — Thu, 25 Jun 2015 08:44:19 GMT

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

ericheleine — Thu, 25 Jun 2015 09:25:55 GMT

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 — Thu, 25 Jun 2015 12:34:07 GMT

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