topic Difference between minstring and firstvalue? in QlikView

Difference between minstring and firstvalue?

Mon, 27 Feb 2012 10:02:33 GMT

Hi everyone,

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

Thanks,

Murali

Difference between minstring and firstvalue?

CELAMBARASAN — Mon, 27 Feb 2012 10:08:16 GMT

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

Difference between minstring and firstvalue?

Mon, 27 Feb 2012 10:18:25 GMT

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

Thanks,

Murali

Difference between minstring and firstvalue?

CELAMBARASAN — Mon, 27 Feb 2012 10:25:04 GMT

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