4 Replies Latest reply: Jan 19, 2010 10:50 AM by Miles Simpson RSS

    QlikView - Simplifying/Flattening Input data

       

      Hey all,


      I'm looking for a way to remove a dimension (in this case time) of data within QlikView.

      As a simplified example, if I'm pulling data from an external database that has an account number, date and an amount for each record and wanted my final QlikView table to have a unique account number and only the date and amount for the most recent transaction... how would I go about it?

      Sample Input could be

      account,date,amount

      12345,20010101,100.00

      12345,20020101,100.00

      12345,20030101,200.00

      23456,20030505,000.00

      23456,20060112,050.00

      34567,19990101,999.99

      45678,20091212,123.45

      45678,20091230,100.00

       

      Sample final QlikView table

      account,date,amount

      12345,20030101,200.00

      23456,20060112,050.00

      34567,19990101,999.99

      45678,20091230,100.00

      Thanks for any tips.