4 Replies Latest reply: Nov 24, 2015 8:20 AM by balraj ahlawat RSS

    Unique invoice mark

    Charles Mogashoa

      Good day

       

      Please assist, i need to create a unique invoice count on a straight table as shown on the attachment.

       

      I need to show a 1 for the top original unique invoice and a 0 for all other duplicates of that invoice number.

       

      For excel i would normally use the formula:   =IF(A2<>A1,1,"")

       

      What is the good solution for qlikview using sql data source?