Aggregate function in Set Analysis with and without $ Expansion

[kamal_sanguri]

Hi,

I was trying using Min/Max aggregate function in Set Analysis. I used function in different way and got different result.

                                                                        LOAD SCRIPT

**********************************************************************************************************************************************

Data:

Load *

Inline

[

Marks, Name

150, A

250, B

120, C

320, D

188, E

235, F

354, G

199, H

297, I

];

NewData:

Load

  Max(Marks) as MaxMarks

Resident Data;

Let MaxMarks = Peek('MaxMarks',0,'NewData');

Drop Table NewData;

**********************************************************************************************************************************************

Function : =Concat({<Marks={"$(=Min(Marks))"}>}Name,';')

Output: C

Function : =Concat({<Marks={"=Min(Marks)"}>}Name,';')

Output: A;B;C;D;E;F;G;H;I

It seems, in second case.. it is going row by row but I think, it should not be the case when use set..

Please share your thoughts..!!

Thanks,

-Kamal

[kamal_sanguri]

Thanks for quick response, the reason why I asked this was.. if I want to calculate row by row and want to have all the items concatenated.. I can easily use..

=Concat(Name,' ;')