0 Replies Latest reply: Sep 1, 2010 8:30 PM by true73417 RSS

    How to sum and aggregate records for inconsistent most recent date for customer and product combinations?

    true73417

      Hi,

      Below is a requirement I'm trying to calculate in Qlikview.

      Find the most recent Order date for Customer and Product combination. The most recent date isn't always the same.

      After I have a unique Customer, Product, most recent Order Date combination I'd like to do then sum up the sales for this combination on this date.

      I've tried using aggr etc but somehow I'm missing something with the syntax. Syntax would be helpful!!

      Thanks,

      Dan