Multi box filter expression help - Qlik Community

Report Inappropriate Content · ‎2011-06-29

I have the following expression in a multi box in QlikView. What I am trying to do is have my document filter so that if either TeamResponsible or ManagerResponsible is equal to "Client", display the record when "Client" is selected. Otherwise, the record should display when "Us" is selected.

Expression:

=if(TeamResponsible <> 'Client' and ManagerResponsible <> 'Client', 'Us', 'Client')

When I select "Us", the document seems to be filtering correctly, and displays everything that does not have a value of "Client" for either the ManagerResponsible or TeamResponsible field. When I select "Client", rather than "Us", it displays everything, rather than just those records that have a value of 'Client' for either the TeamResponsible or Manager Responsible fields.

TeamResponsible and ManagerResponsible can either have a value of Client, Us, blank, or null.

Should what I have be working, or do I need to take a different approach?

Thank you.

m_woolf · ‎2011-06-29

Try this:

=if(TeamResponsible = 'Client' or ManagerResponsible ='Client', 'Client','Us')

Report Inappropriate Content · ‎2011-06-30

This results in the same thing - selecting Us works correctly, but selecting Client brings up everything.

kaushiknsolanki · ‎2011-06-30

HI,

Please upload the qvw file.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!