Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Show only some dimensions members

Hello

I have a simple Bar chart with One Dimension and One Expression.

The dimension has 4 members:

A

B

C

D

How can I show members A, B and C only by default, in the chart?

Thanks

1 Solution

Accepted Solutions
swuehl
MVP
MVP

I assume you want to be able to add D later on? If you never want to show D, you could use a calculated dimension

=if(DIMENSION <> 'D',DIMENSION)

or set analysis in all your expressions, like

=sum( {<DIMENSION -= {D}>} VALUE)

If you want to be able to add D later on, what is your definition of by default? When you enter a tab or open the document? Should only one chart be affected by the default selection or all?

View solution in original post

1 Reply
swuehl
MVP
MVP

I assume you want to be able to add D later on? If you never want to show D, you could use a calculated dimension

=if(DIMENSION <> 'D',DIMENSION)

or set analysis in all your expressions, like

=sum( {<DIMENSION -= {D}>} VALUE)

If you want to be able to add D later on, what is your definition of by default? When you enter a tab or open the document? Should only one chart be affected by the default selection or all?