topic Re: Exclude multiple values in charts,tableboxes in QlikView

Exclude multiple values in charts,tableboxes

Mon, 12 Mar 2012 16:17:24 GMT

Hello Community,

i have a problem in a chart. For example. I have departments in the first column. Second one ist an expression.

So i need to filter the departments.

Department Expression

a 12

b 24

c 31

d 48

e -

So what i need is a permanent filter on the department column ONLY in this chart. Like: Department in (a,c,e).

Department Expression

Thanks for any help.

Re: Exclude multiple values in charts,tableboxes

jvitantonio — Mon, 12 Mar 2012 16:21:39 GMT

Here it is

Re: Exclude multiple values in charts,tableboxes

Miguel_Angel_Baeyens — Mon, 12 Mar 2012 16:23:15 GMT

Hi,

You can either do the selections, then detach the chart, create an state and make the chart inherit it or rather use set analysis in your expressions, so if your current expression is

Sum(Value)

You use set analysis to show only those values

Sum({< Department = {'a', 'c', 'e'} >} Value)

You can save this values into a bookmark and use the bookmark in the set analysis also

Sum({BM01} Value)

Where BM01 is the ID of the bookmark where you store those department selections.

Hope that helps.

Miguel

Re: Exclude multiple values in charts,tableboxes

magavi_framsteg — Mon, 12 Mar 2012 16:24:41 GMT

Hi Jan.

You can change the Department dimension to be a calculated dimension by selecting "Expression..." instead of the field Department.

Then your expression could be something like:

if (Department = 'a' OR Department = 'c' OR Department = 'e', Department)

Or if you prefere sets, which I think is more effective in this case, you could use:

{<Department={'e','c','a'}>}

Kind regards

Magnus Åvitsland

BI Consultant

Framsteg Business Intelligence Corp.

Re: Exclude multiple values in charts,tableboxes

Wed, 22 Apr 2015 14:05:29 GMT

Hi Juan,

I have been trying to figure this out for months and couldn't find a direct and to the point answer. You provided that for me! I know it's been 3 years since this post but just wanted to say THANK YOU, if you are still part of the Qlik Community;)

Barb