topic Max and FirstSortedValue across two fields in QlikView https://community.qlik.com/t5/QlikView/Max-and-FirstSortedValue-across-two-fields/m-p/81460#M13364 <HTML><HEAD></HEAD><BODY><P>PFA my sample data. The requirement is fairly simple.</P><P></P><P>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. </P><P></P><P>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).</P><P></P><P><IMG alt="maxvalues2.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/192986_maxvalues2.PNG" style="height: 152px; width: 620px;" /></P><P></P><P style="font-size: 13.3333px;">I started with this script but it takes into account just the Nett Value, not the CapitalFlag</P><P style="font-size: 13.3333px;"><IMG alt="maxvalues.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/192967_maxvalues.PNG" /></P></BODY></HTML> Fri, 09 Feb 2018 14:40:24 GMT shane_spencer 2018-02-09T14:40:24Z Max and FirstSortedValue across two fields https://community.qlik.com/t5/QlikView/Max-and-FirstSortedValue-across-two-fields/m-p/81460#M13364 <HTML><HEAD></HEAD><BODY><P>PFA my sample data. The requirement is fairly simple.</P><P></P><P>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. </P><P></P><P>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).</P><P></P><P><IMG alt="maxvalues2.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/192986_maxvalues2.PNG" style="height: 152px; width: 620px;" /></P><P></P><P style="font-size: 13.3333px;">I started with this script but it takes into account just the Nett Value, not the CapitalFlag</P><P style="font-size: 13.3333px;"><IMG alt="maxvalues.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/192967_maxvalues.PNG" /></P></BODY></HTML> Fri, 09 Feb 2018 14:40:24 GMT https://community.qlik.com/t5/QlikView/Max-and-FirstSortedValue-across-two-fields/m-p/81460#M13364 shane_spencer 2018-02-09T14:40:24Z