topic IF statements for custom fields showing no data in QlikView

IF statements for custom fields showing no data

Wed, 06 Sep 2017 11:43:14 GMT

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 !

Re: IF statements for custom fields showing no data

marcus_sommer — Thu, 07 Sep 2017 10:42:36 GMT

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

Re: IF statements for custom fields showing no data

rohitraut — Thu, 07 Sep 2017 11:12:03 GMT

Hello Jacob,

try this,

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

Re: IF statements for custom fields showing no data

shraddha_g — Thu, 07 Sep 2017 11:16:06 GMT

You can try,

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

If possible share sample data n expected output.