topic Re: Dimension expression help in QlikView

Dimension expression help

Wed, 22 May 2013 15:24:10 GMT

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!

Manager	Associate	State	Production
Simon	Jan Harlow	LA	$300
Bob	Frank Smith	CA	$2800
Joe	Dan Ly	TX	$250
Simon	Bill Allen	FL	$700
Joe	James Mint	NV	$1200
Simon	Donna Spelding	FL	$800

Re: Dimension expression help

m_woolf — Wed, 22 May 2013 20:05:15 GMT

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

Re: Dimension expression help

Wed, 22 May 2013 20:16:42 GMT

Hi,

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

Rebeca

Re: Dimension expression help

jpapador — Wed, 22 May 2013 20:42:57 GMT

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

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

Re: Dimension expression help

Thu, 23 May 2013 13:40:18 GMT

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

Re: Dimension expression help

Thu, 23 May 2013 13:45:38 GMT

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!