Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register 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