Fieldindex and fieldvalue.

[#1]

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

[#2 · Accepted solution]

Hi,

try this:

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

c u,

Stefano.

[#3]

Hi Steen

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

Is this what you need?

Thanks

Priya

[SunilChauhan]

try one of below

if(F1='f',F2)

or

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