2 Replies Latest reply: Oct 21, 2010 9:03 AM by David Carlin RSS

    Suppressing older date records against a record

      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