Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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