variable with maximum week

gr_eldred — Thu, 02 Nov 2017 22:00:57 GMT

hi I have a qvd that contains a column with the week number.

I need to get the maximum week and put it in a variable.

is it valid to do this?

let vmaxsemana = LOAD

max (SemamaYearApple_Number) as SemamaYearApple_Number

from

Transformation \ Dim \ CalendarApple.qvd;

Can you help me?

Re: variable with maximum week

swuehl — Thu, 02 Nov 2017 22:05:04 GMT

No, you need to do it like this

MaxTable:

LOAD

Max(FIELD) as MaxValue

FROM ....;

Let vMaxValue = Peek('MaxValue',0,'MaxTable');