Exclude multiple values in charts,tableboxes

[#1]

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

a

c

e

Thanks for any help.

[jvitantonio]

Here it is

[Miguel_Angel_Baeyens]

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

[magavi_framsteg · Accepted solution]

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.

[#5]

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