Peek function problem

Thu, 14 Mar 2013 15:15:27 GMT

Hi, I'm trying to calculate Delta of Sales between adjacent months but it always compare with Month number 12

Ventas_Mes. Here is the whole script, any idea? Thanks in advance!:

LOAD * INLINE [

    Mes, Ventas

    5, 32

    3, 34

    2, 2

    4, 44

    1, 65

    7, 88

    6, 56

    8, 44

    9, 12

    12, 23

    11, 33

    10, 45

];

NoConcatenate

VentasMesesOrdenados:

LOAD

Mes,

Ventas

RESIDENT Ventas_Mes

Order by Mes Asc;

drop Table Ventas_Mes;

LOAD

Mes &'-'&Peek('Mes',-1,'VentasMesesOrdenados') as DeltaMes,

Ventas - Peek('Ventas',-1,'VentasMesesOrdenados') as DeltaVentas

Resident VentasMesesOrdenados;

Re: Peek function problem

Thu, 14 Mar 2013 16:07:07 GMT

Hola Tatiana,

Hablas español? Tu script funciona. mejor escribeme en este idioma para entender mejor tu problema.

Saludos,

Ricardo

Re: Peek function problem

Thu, 14 Mar 2013 16:54:12 GMT

Adjunto un fichero con la solucion

topic Peek function problem in QlikView

Peek function problem

Re: Peek function problem

Re: Peek function problem