topic Grouping by different Dimension in script in QlikView

Grouping by different Dimension in script

prathipsrinivas — Mon, 22 Oct 2018 08:08:55 GMT

Hi All,

I could really use your technical expertise here.

The requirement is to sum the values of Maximum transaction of Max Entry Date for particular Currency in a Particular policy.

I would understand I need to implement it by group by using Entry date, transaction, currency, policy.

But it was not giving expected results.

Any ideas how to implement this?

Thanks,

Prathip

swuehl — Mon, 22 Oct 2018 08:16:57 GMT

Could you give some sample records and your expected result of how to sum the values?

Anil_Babu_Samineni — Mon, 22 Oct 2018 08:30:58 GMT

You can use Directly like

Load Field1, Field2, .., FirstSortedValue(Transaction, -[Entry date)) as Max_Transaction Group By Field1, Field2...