topic Re: Concat first sorted value in QlikView

Concat first sorted value

jamelmessaoud — Wed, 25 Nov 2020 16:16:04 GMT

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

sunny_talwar — Wed, 18 Apr 2018 11:06:23 GMT

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

jamelmessaoud — Wed, 18 Apr 2018 11:13:17 GMT

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

Thanks

sunny_talwar — Wed, 18 Apr 2018 11:15:59 GMT

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