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.
Re: IF statements for custom fields showing no data
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.