Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
jamelmessaoud
Creator II
Creator II

Concat first sorted value

Hi guys,

I have a first sorted value expression which I would like to concat but I cannot figure out the correct way to do this.

The current expression I have is

firstsortedvalue(Supplier, -Aggr(max([Suppliers FTL Cost]),Supplier))

I would like to concat results of this if that's possible?

Thanks

J

3 Replies
sunny_talwar

FirstSortedValue always gives a single output... in order to see multiple outputs, you need to use Concat() function with Aggr() function

jamelmessaoud
Creator II
Creator II
Author

Ok.  Can I do that on the current expression which I have or not possible?

Thanks

sunny_talwar

do what on the current expression? I am not sure I understand your question