IF statements for custom fields showing no data

[#1]

I'm fairly new to Qlik and have some issues getting an IF statement to pull through the data from a customised fields in a table.  I have done this on multiple fields with a range of ways and still retrieve no results.  The field titles will vary, but here is an example of a statement that I've used:

IF (contract_field_title = 'activity', contract_field_answer_value)

I am wanting to show the response from the column called activity but this only draws blanks. I have also tried using LIKE and a wild card instead of equals for the field title.

The data in the fields in either in a text box format where anything can be entered, or from a multi choice selection - I don't believe this should make a difference?

If anyone has any thoughts or suggestions, that'd be appreciated. 

Thanks !

[marcus_sommer]

I think you need to provide more informations about what you are want to do - for example a screenshot from the datamodel, a few example-records from your data, script or gui and where is which result expected.

- Marcus

[rohitraut]

Hello Jacob,

try this,

IF (contract_field_title = 'activity', sum(contract_field_answer_value))

[shraddha_g]

You can try,

if(wildmatch(contract_field_title ,'activity'),contract_field_answer_value) .

If possible share sample data n expected output.