Using an expression to map to another field

[#1]

I have a table of mapped values that I want to match to a calculated expression.  I am using an If statement to display the mapped value after the calculated expression = another value in the table.  I am getting no results.

=If(([Mean Score])) = Mean,Percentile,0)

Mean Score is the calculated expression

I want to match it to Mean in the table and display the Percentile associated with it.

I am continuing to get '0' returned.

Do I need to load the table as a Mapped table or can I do this as an expression?

[#2]

Hey Mary is the table containing mapped values an island table in qlikview. Also is it possible that Mean Score result is not exactly similar to Mean. like -

Mean Score = 63.45  and if Mean = 63 then the If would fail and always show 0. I believe that could be the issue. Can you please check that ?

[avinashelite]

Hi Mary,

Can you please share your app, will check the issues.

[#4]

( { < [Mean Score] = P({$} Mean)>} Percentile )

but then you can see if you can put text or num around it, I haven't done this.

ie:

NUM(( { < [Mean Score] = P({$} Mean)>} Percentile ),'###.##');

IN A set expression.

[udit_kumar_sana]

Hi,

Pls find the attached file which will help u.

The format of Mean Score and Mean need to be same.

Thanks & Regards,

Udit

[#6]

Thanks for all your suggestions.  I'll try and see if any of this works and let you know.