4 Replies Latest reply: Sep 30, 2016 8:56 AM by Blaine Hyde RSS

    Excel array functionality in Qlik Sense

      Trying to replicate the excel functionality of an array function of: =MIN(IF($AJ$4:$AJ$50002=AJ2,$AK$4:$AK$50002)) in Qlik Sense.  AJ is a variable, e.g., order number and I'm seeking to find the minimum chronological transaction number in AK.  Basically want to return the first (min) transaction number in each record of a given order number.  Help!