Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Perhaps like this:
If(MyFieldB = above(MyFieldB) and MyFieldO <> above(MyFieldO), above(MyFieldL) + 1 , 1)
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?