topic Re: Using combined (conjoined) filters in QlikView

Using combined (conjoined) filters

Sun, 27 Nov 2011 02:14:46 GMT

In want to exclude sales manager 'james' "in" region 'south' on my sales dashboard.

So when James pops up in region north that is no problem

When clicking south in the listbox of the regions, and excluding clicking salesmanager james in the salesmanager listbox I only retrieve the numbers regarding region south.

What can I do to employ a correct interpretation?

Using combined (conjoined) filters

lironbaram — Sun, 27 Nov 2011 08:21:14 GMT

you need to do it like this

select james

then select South

then do select excluded on the region field

if you wnat it in a formula you can use set analysis

sum({<manager={james}, Region=-{South}>}sales)+ sum({<manager=-{james}>}sales)

Re: Using combined (conjoined) filters

Sun, 27 Nov 2011 13:37:57 GMT

Hi Liron, This does not work.

It excludes the region while selecting only james. So now I solely have the name james rather than all sales managers.

I didn't try the set formula because is essential for my end-users to be capable to exclude in such way using easy navigation.