topic Re: Selecting all except exclusions in QlikView

Selecting all except exclusions

Thu, 02 Oct 2014 15:44:03 GMT

I have a scenario where I want to display data based on exclusions rather than selections. (It came up on a webinar this morning but wasn't answered at the time).

For example if I had a list of all cost centres and was displaying data based on all these cost centres, ie total spend, but then had a need to exclude some, say those representing capital spend. I don't want to have to select cost centres individually; I want to select the capital spend group and display the the total spend from the cost centres that remain when the capital spend cost centres are excluded.

Any guidance gratefully accepted.

Re: Selecting all except exclusions

alexandros17 — Thu, 02 Oct 2014 15:47:55 GMT

Take a look to set analysis help search for E use with which you can exclude selections, really easy to use.

Re: Selecting all except exclusions

bgerchikov — Thu, 02 Oct 2014 15:53:17 GMT

Hi Gareth,

In addition to element function E, I'd suggest to use "-" in Set Analysis as follows:

CostCenter -={"Some Value"}

Hope it will help

Re: Selecting all except exclusions

ashfaq_haseeb — Thu, 02 Oct 2014 16:37:54 GMT

Hi,

Try something like this

=sum( {$<CostCenter= E({$} CostCenter)>} Sales )

Regards

ASHFAQ