Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
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 !

Tags (2)
3 Replies
MVP & Luminary
MVP & Luminary

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.

- Marcus

rohitraut
Contributor

Re: IF statements for custom fields showing no data

Hello Jacob,

try this,

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

shraddha_g
Honored Contributor III

Re: IF statements for custom fields showing no data

You can try,

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

If possible share sample data n expected output.