Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

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

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

Community Browser