topic Re: Using an expression to map to another field in QlikView

Using an expression to map to another field

Wed, 31 Dec 2014 16:28:05 GMT

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?

Re: Using an expression to map to another field

Wed, 31 Dec 2014 22:33:47 GMT

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 ?

Re: Using an expression to map to another field

avinashelite — Thu, 01 Jan 2015 06:17:48 GMT

Hi Mary,

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

Re: Using an expression to map to another field

Thu, 01 Jan 2015 07:16:46 GMT

( { < [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.

Re: Using an expression to map to another field

udit_kumar_sana — Thu, 01 Jan 2015 14:28:00 GMT

Hi,

Pls find the attached file which will help u.

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

Thanks & Regards,

Udit

Re: Using an expression to map to another field

Fri, 02 Jan 2015 14:47:04 GMT

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