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?