Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Dimension expression help

I am trying to write an expression for the below Associate dimension that will display all agents except the agents that work for Simon who do not reside in Florida.  If an associate works for another manager then I do not care where they live.  Below in red is an example of the results that I am trying to produce:

Thanks in advance!

ManagerAssociateStateProduction
SimonJan HarlowLA$300
BobFrank SmithCA$2800
JoeDan LyTX$250
SimonBill AllenFL$700
JoeJames MintNV$1200
SimonDonna SpeldingFL$800

If

5 Replies
m_woolf
Master II
Master II

=if(not(Manager='Simon' and State <> 'FL'),Associate)

Not applicable
Author

Hi,

=if(Manager<>'Simon' and State <> 'LA',Associate)

Rebeca

jpapador
Partner - Specialist
Partner - Specialist

If Production is a expression.  Use a straight table and make your expression

Sum({$<Manager-={'Simon'}, State-={'<>FL'}>}Production)

Not applicable
Author

This is helpful but the expression isnt removing the associates who work for Simon that do not live in FL.

Not applicable
Author

Hi! Thanks for your response but I tried this expression and it removes all of Simon's associates.  I just want to remove the ones who work for Simon that do not work in FL. Thanks again!