topic how to load mathematical operations?? in QlikView

how to load mathematical operations??

chematos — Wed, 22 Feb 2012 13:58:53 GMT

I'm starting to develop with QlikView...

My idea is to create a dynamic table with ranks. I have the maximum value of a resident table and I calculate the number of ranks, that it's the value of $(rangos).

I want to know if it´s possible to do the colored in red operation and how is the syntax, please.

If there is another way easier to do all I said before, please tell me.

Thank you.

Acepto respuestas en Español, gracias.

MAXIMO:

LOAD max(T7) as mayor Resident TRANSACCION;

let maxValor = Peek('mayor', -1, 'MAXIMO');

let rangos = $(maxValor)/500;

If(IsPartialReload())then

FOR i=1 to $(rangos)

INTERVALOS:

LOAD * INLINE [

Rango, Valor

$(i), 500*$(i)

];

how to load mathematical operations??

CELAMBARASAN — Wed, 22 Feb 2012 14:03:34 GMT

Hi,

Instead of inline you can try with this

MAXIMO:

LOAD max(T7) as mayor Resident TRANSACCION;

let maxValor = Peek('mayor', -1, 'MAXIMO');

let rangos = $(maxValor)/500;

If(IsPartialReload())then

FOR i=1 to $(rangos)

INTERVALOS:

LOAD

$(i) as Rango,

500*$(i) as Valor

Autogenerate 1;

hope it helps

Celambarasan

how to load mathematical operations??

jagan — Wed, 22 Feb 2012 14:09:49 GMT

FOR i=1 to $(rangos)

Hi,

Try the below script

INTERVALOSTemp:

LOAD * INLINE [

Rango

$(i)

];

INTERVALOS:

LOAD

Rango,

Rango*500

RESIDENT INTERVALOSTemp;

DROP TABLE INTERVALOSTemp;

Hope this helps you.

Regards,

Jagan.

how to load mathematical operations??

chematos — Wed, 22 Feb 2012 14:14:59 GMT

Hi,

absolutly perfect, thank you very much!

José