Load Script If Functions

[LB187]

Hi i am looking for the correct function to create a new field within a table that will "rank" each client dependent on certain conditions....for example in excel this would look something like....

IF(B2<>B1,1,
IF(AND(B2=B1,O2=O1),1,
IF(AND(B2=B1,O2<>O1),L1+1)))

In Qlik I am unsure how to translate this so it ranks my data?

[Gysbert_Wassenaar]

Perhaps like this:

If(MyFieldB = above(MyFieldB) and MyFieldO <> above(MyFieldO),  above(MyFieldL) + 1 , 1)

[LB187]

Thanks for this I think it works but the only issue is that in the example above (MyFieldL) is simply a "1" in Excel and ads another 1 becoming 2 if the other aspects of the formula are met thus resulting in a 2 and a 3 and so on?