topic Does LastValue only work with strings? in QlikView

Does LastValue only work with strings?

Fri, 01 Oct 2010 15:30:12 GMT

Hi,

In my load script, I'm trying to capture the last value (in load order) of a numeric field using the LastValue function (I've also tried FirstSortedValue with a negative sort-weight) but it only seems to work with non-numeric data. The help text seems to back this up stating that "If no text value is found, NULL is returned."

Is this correct and if so is there an equivalent numeric function?

Thanks all,

Rich

Does LastValue only work with strings?

Fri, 01 Oct 2010 15:41:51 GMT

hi richhoos

I'm not really sure that I understand what you need, but I you want to capture a value , I think that peek() will do great.

In your situation : peek('your table',-1)

I hope it will help you,

Will

Does LastValue only work with strings?

Fri, 01 Oct 2010 15:43:01 GMT

I've figured it out!

The last value was null. It DOES work with numeric data.