Discussion Board for collaboration related to QlikView App Development.
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
Could you give some sample records and your expected result of how to sum the values?
You can use Directly like
Load Field1, Field2, .., FirstSortedValue(Transaction, -[Entry date)) as Max_Transaction Group By Field1, Field2...