Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
Sorry I am new to Qlikview and used to using Crystal reports.
I have written a Qlikview report that looks to data in our SQL database.
The report looks to invoices chased and the date promised by the client. However if another chase is entered against the client it shows this also. I need to somehow only show the latest Promised Date and remove the older chases. See below what I have now.
The report automatically removes all paid invoices so I will then be able to put a date range againt this to show all overdue promised invoices.
Account | Account Name | Controller Name | Transaction Reference (XXTREF) | Query Description (QCDESC) | Account Ledger (SALEDG) | Promised Date | Promised Value | test | Original Gross | Original VAT | Original Net | Outstanding Value | |
Total | 913.21 | 136.01 | 777.2 | 913.21 | |||||||||
HD00385 | xxx Services Ltd | Jane Callaway | IN047496JI | SLSERVICE | 31/10/2010 | £913.21 | 913.21 | 136.01 | 777.2 | 913.21 | |||
HD00385 | xxx Services Ltd | Jane Callaway | IN047496JI | SLSERVICE | 02/11/2010 | £913.21 | 913.21 | 136.01 | 777.2 | 913.21 |
Anyone know the best way to achieve this??
Many Thanks
Dave
Hi Dave,
see the attached example for help.
Good luck!
Rainer
Thankyou so much ... that has done the trick
Cheers