Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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
mwoolf
Honored Contributor II

Re: Dimension expression help

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

Not applicable

Re: Dimension expression help

Hi,

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

Rebeca

jpapador
Valued Contributor

Re: Dimension expression help

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

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

Not applicable

Re: Dimension expression help

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

Not applicable

Re: Dimension expression help

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!

Community Browser