If condition in filter doesn't work

[marcobis]

Hi all, I'm new to Qlik Sense and I have a problem with a filter not working with an If statement, so this is the situation:

1 table SALES which has 2 columns QK_ANAGENT and QK_ANAGENT_2 linked respectively with two tables AGENT and AGENT_2, this is the If statement:

=if(QK_ANAGENT_2 <> 'DFL/0',[AGENT_2.DES_AGENT],[AGENT.DES_AGENT])

so if there is a second agent it must return the second agent description, else the first agent description. The filter is not working. Any suggestions?

Qlik Sense Desktop

#

[BrunPierre]

How about this?

=If(Not Wildmatch(QK_ANAGENT_2 ,'*DFL/0*'),[AGENT_2.DES_AGENT],[AGENT.DES_AGENT])

[vinieme12]

can one record in SALES table be associated to more than one record in AGENT and AGENT_2 ?

[marcobis · Accepted solution]

Thank you all, I have resolved this with a calculated field on the table SALES linked with table AGENT.