Difference between minstring and firstvalue?

[#1]

Hi everyone,

Can anybody explain the difference between minstring and firstvalue string aggregation functions?

Thanks,

Murali

[CELAMBARASAN]

Hi,

     Firstsortedvalue returns the first sorted value based on other fields(if given) or within the same field.

     MinString is to return the first value within the field we cann't sort by using another field.

Celambarasan

[#3]

But my question is about firstvalue and minstring, not firstsortedvalue.

Thanks,

Murali

[CELAMBARASAN · Accepted solution]

Hi,

     Yep ok.First value can be used only in load script not in the presentation which returns the first value based on the load order.But MinString returns the First sorted string or numeric value.

     Example load order is

     4,5,2,3,5,6

     FirstValue returns 4 whereas MinString returns 2.

Hope it helps

Celambarasan