topic Load Script If Functions in App Development

Load Script If Functions

LB187 — Thu, 23 Jun 2022 12:35:07 GMT

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?

Re: Load Script If Functions

Gysbert_Wassenaar — Thu, 23 Jun 2022 13:32:00 GMT

Perhaps like this:

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

Re: Load Script If Functions

LB187 — Thu, 23 Jun 2022 14:20:11 GMT

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?