4 Replies Latest reply: Sep 26, 2017 9:26 AM by Paula van der Velde RSS

    Hi, is there anybody who could tel me what kind of function I should use in QlikSense to get a result similar to the below expression in Excel?

    Paula van der Velde

       

      =IF(ISNA(INDEX($B:$K,MATCH($C19555,B:B,0),10)),IF($K19555=0,"Perfect",IF($K19555>0,"New")),IF(INDEX($B:$K,MATCH($C19555,B:B,0),10)=0,IF($K19555>0,"New",IF($K19555=0,"Perfect")),IF(INDEX($B:$K,MATCH($C19555,B:B,0),10)>0,IF($K19555>0,"Existing",IF($K19555=0,"Solved")))))