Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Specialist
Specialist

Max and FirstSortedValue across two fields

PFA my sample data. The requirement is fairly simple.

For each [Transaction Reference] I want 1 row. | want the field value returned based on firstly the Max [CapitalFlag] then then Max [Nett Value]. i.e. No matter what the max Nett Value is the higher CapitalFlag (i.e. 8 not 1) will take presidence.

So for this example it would be the second row. Even thought the Nett Value isn't highest the Capital Flag is higher (8 not 1).

maxvalues2.PNG

I started with this script but it takes into account just the Nett Value, not the CapitalFlag

maxvalues.PNG

0 Replies