Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

ericheleine
New Contributor II

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)

thank you for your help

eric

4 Replies
Not applicable

Re: How using If for 2 input identical

hi

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

     min( Amount order1),

     min( Amount order2)

)

jsingh71
Valued Contributor

Re: How using If for 2 input identical

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

ericheleine
New Contributor II

Re: How using If for 2 input identical

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
New Contributor II

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