Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
prathipsrinivas
Contributor

Grouping by different Dimension in script

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

Tags (2)
2 Replies
MVP
MVP

Re: Grouping by different Dimension in script

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

Re: Grouping by different Dimension in script

You can use Directly like

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)