variable with maximum week

[gr_eldred]

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?

[swuehl · Accepted solution]

No, you need to do it like this

MaxTable:

LOAD

     Max(FIELD) as MaxValue

FROM ....;

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