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