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!
Thanks for the response. After digging in I may have a complicating factor that is causing the below to bomb out with the subsequent Qlik Sense error. My order number ends up having to be the combination of two precursors, Order!&OrderB making up a created OrderNo.
OrderA&OrderB as OrderNo,
Min (TransactionNo)as FirstTransaction
The following error occurred:
The error occurred here:
Left Join(Order) Load OrderNo, Min (TransactionNo)as FirstTransaction Resident Order