Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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:
Strange, I don't think how it returns. Would you provide data where you get it this? Table box / Which object?
Rahul,
thank you very much!!!!!!!!!!
Doug
On Thu, Mar 30, 2017 at 11:18 PM, Anil Babu Samineni <