Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Exclude multiple values in charts,tableboxes

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.

1 Solution

Accepted Solutions
magavi_framsteg
Partner - Creator III
Partner - Creator III

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.

View solution in original post

4 Replies
jvitantonio
Luminary Alumni
Luminary Alumni

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
Partner - Creator III
Partner - Creator III

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.

Not applicable
Author

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