Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

IF statements for custom fields showing no data

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 !

3 Replies
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
Creator
Creator

Hello Jacob,

try this,

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

shraddha_g
Partner - Master III
Partner - Master III

You can try,

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

If possible share sample data n expected output.