topic Fieldindex and fieldvalue. in QlikView

Fieldindex and fieldvalue.

Fri, 30 Sep 2011 09:21:02 GMT

Hi,

In my load script I am loading the following values (parameters):

LOAD * INLINE [

F1, F2

a, 10

b, 20

c, 30

d, 40

e, 40

f, 30

g, 20

h, 10

];

In my presentation I want to access the F2-value of F1-'f' and tried the following:

FieldValue('F2', FieldIndex('F1','f')) - but this does not give the desired result.

I can see why this happens, since there are duplicate values in the F2-column, so you end up with 8 rows in the F1-column, but only 4 rows in the F2-column, due to QV's elimination of duplicates.

Is there a way of getting to the correct value for my 'f'-record?

Example is attached as well

Help is highly appreciated

Best regards

Steen Olesen

Fieldindex and fieldvalue.

Fri, 30 Sep 2011 09:37:38 GMT

Hi,

try this:

only({<F1={'f'}>}F2)

c u,

Stefano.

Re: Fieldindex and fieldvalue.

Fri, 30 Sep 2011 09:38:14 GMT

Hi Steen

Please use =only(F2) in a text object.

Is this what you need?

Thanks

Priya

Fieldindex and fieldvalue.

SunilChauhan — Fri, 30 Sep 2011 12:57:24 GMT

try one of below

if(F1='f',F2)

sum( if(F1='f',F2))