Multi box filter expression help

Wed, 29 Jun 2011 18:52:59 GMT

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.

Multi box filter expression help

m_woolf — Wed, 29 Jun 2011 20:31:56 GMT

Try this:

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

Multi box filter expression help

Thu, 30 Jun 2011 12:14:55 GMT

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

Multi box filter expression help

kaushiknsolanki — Thu, 30 Jun 2011 12:19:12 GMT

HI,

Please upload the qvw file.

Regards,

Kaushik Solanki

topic Multi box filter expression help in QlikView

Multi box filter expression help

Multi box filter expression help

Multi box filter expression help

Multi box filter expression help