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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
restrep101
Contributor
Contributor

Excluding values on one specific graph in a sheet

I have a bar graph in a sheet that has the following categories as a dimension (apple, banana, starfruit, and grapefruit) I want to remove apple and banana from the graph but not from the other graphs on the sheet. I have tried: 

{<FruitName={'starfruit','grapefruit'}>}

which is auto-generated by the set expressions and a bookmark I created. But then I get an error message:

Error in expression

garbage after expression:'='

{<FruitName={'starfruit','grapefruit'}>}

 

How can I exclude values or dimensions on one graph?

Labels (1)
3 Replies
Or
MVP
MVP

That needs to go inside an aggregation function, e.g.

Count({<FruitName={'starfruit','grapefruit'}>} FruitName)

restrep101
Contributor
Contributor
Author

Thank you! there is no error code anymore but now when I get out of the expression editor it states that it is an invalid dimension

Or
MVP
MVP

It should be a measure...