Discussion Board for collaboration on QlikView Scripting.
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
if(Hours = trader and trader =portfolio and portfolio <> Side,
min( Amount order1),
min( Amount order2)
Please share some sample data so it will easy to write the correct expression.
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