This content has been marked as final. Show 4 replies
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?