Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Excluding dimension values

Hi.

I need to create a chart with some dimensions and measures.

For one dimensions I need to exclude some values to don't show the related measure values. For this dimension I haven't to create a list box with the dimension values. I think to edit the dimension inside the chart.

Any suggests to me, please? Thanks

1 Solution

Accepted Solutions
erichshiino
Partner - Master
Partner - Master

You may edit the dimension expression on a chart (creating a calculated dimension).

for example

if(Year>2000,Year).

Another option is to use set analysis in all your expressions in the chart to exclude dimensions that get null results.

Rgds,

Erich

View solution in original post

2 Replies
erichshiino
Partner - Master
Partner - Master

You may edit the dimension expression on a chart (creating a calculated dimension).

for example

if(Year>2000,Year).

Another option is to use set analysis in all your expressions in the chart to exclude dimensions that get null results.

Rgds,

Erich

Not applicable
Author

Ok, thanks, it is a good tip.