5 Replies Latest reply: Jun 15, 2018 2:59 AM by Christophe Brault RSS

    Identify missing sequential number

    Jeffrey Lin

      Hi Everyone,

       

      I wanted to inquire if there's an expression code to calculate a sequential missing number in Qliksense

       

      Eg.
      Invoice Numbers

      1. 1000020
      2. 1000021
      3. 1000022
      4. 1000023
      5. 1000024
      6. 1000026
      7. 1000027
      8. 1000029
      9. 1000031

           ..........

       

      Expected Output: 1000025, 1000028, 1000030

       

      In excel I can perform this using  =IF(ISNA(VLOOKUP(ROW(A1),$A1:$A$13,1,FALSE)),ROW(A1),"")

       

      Is there an expression code I can use in Qliksense table to indicate the missing numbers ?