topic Group by question in QlikView

Group by question

chematos — Mon, 25 Jun 2012 18:25:03 GMT

Hi everyone,

This is the thing:

Imaging that I have this fields:

Group

swuehl — Mon, 25 Jun 2012 18:59:37 GMT

You have only one Amount record per Date, Category and Group or do you need to sum amounts prior getting the max?

I think you could try using max(Amount) and FirstSortedValue:

LOAD

Group,

Category,

max(Amount) as MaxAmount,

FirstSortedValue(Distinct Date, -Amount) as MaxAmountDate

resident YourTable group by Group, Category;

chematos — Mon, 25 Jun 2012 19:28:16 GMT

As successful as ever!

Thank you, it´s a great function this FirstSortedValue.

Regards,

Chema