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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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...