find and identify duplicate invoices in qlikview 12

[sammie0808]

Attached is a short list of invoices.  I want to know how i could find duplicate invoices or duplicate payments to a customer.

Want to make sure I haven't been billed or paid for anything twice or more?

Does anyone know an easy way to do that in qlikview 12.

thanks,

Doug

[rahulpawarb]

Hello Doug,

Trust that you are doing well!

To find the duplicate records I have prepared a draft version of script. This will load the duplicate records into another table using resident load method. Refer below script:

Data:
LOAD *, RowNo() AS SrNo INLINE [
Customers, Invoices, Amount
steve's bike shop, 2458, 30
blairs hot dog stand, 1924, 20
joes hair cut place, 1325, 10
the ski shop, 1688, 20
steve's bike shop, 2458, 30
shoe palace, 8892, 20
super mart, 8812, 10
ralphs eatery, 2615, 45
];

RecordCountData:
LOAD *
Where RecordCount > 1;
LOAD Customers & ' | ' & Invoices & ' | ' & Amount AS [Customers | Invoices | Amount], COUNT(1) AS RecordCount
Resident Data
Group By Customers & ' | ' & Invoices & ' | ' & Amount;

Along with this refer the sample application attached herewith. This includes front end solution using Visual Cues, Background color and Text color settings.

Hope this will be helpful.

Regards!

Rahul

[Kushal_Chawda]

Data:

LOAD Customers,

         Invoices,

        Amount,

        Count(Customers&Invoices&Amount) as Count

FROM Source

group by

Customers,

Invoices,

Amount;

final:

noconcatenate

LOAD if(Count>1,1,0) as DuplicateFlag

Resident Data;

drop table data:

[Anil_Babu_Samineni]

Strange, I don't think how it returns. Would you provide data where you get it this? Table box / Which object?

[sammie0808]

Rahul,

thank you very much!!!!!!!!!!

Doug

On Thu, Mar 30, 2017 at 11:18 PM, Anil Babu Samineni <