topic Re: FieldIndex problem in QlikView

FieldIndex problem

Tue, 28 Aug 2012 17:26:31 GMT

Hello everyone

im having an issue regarding the use of FieldIndex and FieldValue functions.

im using the next expression:

FieldValue('Field2', FieldIndex('Field1',(sum(Venta)/1000)/(sum(Presupuesto)/1000+sum(Ppto)/1000)))

if instead of calculating the value to search i type it it works but i actually need to be calculated.

thanks in advance

Tue, 28 Aug 2012 17:56:13 GMT

i'm not sure your expression gives always an integer value - try to use a floor function

calculate the value outside the chart in a variable

and past it like:

FieldValue('Field2', FieldIndex('Field1',$(vNumber))

Tue, 28 Aug 2012 18:02:43 GMT

Thanks pari pari ive already try that and it works but it brings me the same value for al my table rows

sebastiandperei — Tue, 28 Aug 2012 18:34:30 GMT

Hola alfredo!

Estás seguro que Field1 tiene exactamente el valor que da la expresión?

Agregá otra expresión con (sum(Venta)/1000)/(sum(Presupuesto)/1000+sum(Ppto)/1000) y fijate si ese es el valor exacto que tiene el Field1.

Podés mandar una copia reducida?

Tue, 28 Aug 2012 18:54:02 GMT

Que tal sebastian, si ya he verificado los numeros e incluso les he dado el mismo formato con la funcion num

En un momento mas subo un ejemplo

Wed, 29 Aug 2012 15:26:08 GMT

Here is an example im trying to get the FieldIndex of the value in search in index column

Wed, 29 Aug 2012 15:45:19 GMT

your expresion should look:

FieldIndex('AlcanceReal', floor((sum(Venta)/1000)/(sum(Presupuesto)/1000+sum(Ppto)/1000),0.001))

when you use num(....,'0,001') you only change the display format

Wed, 29 Aug 2012 16:15:25 GMT

Thanks Pari Pari but, with floor it lowers me the result and i need the exact number with the 3 decimals

Wed, 29 Aug 2012 16:18:26 GMT

sorry i wrote it erong now it works thanks a lot pari pari