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

Announcements
Share your agentic AI experience, learn from others, and earn a new badge: Put Agentic AI to Work
cancel
Showing results for 
Search instead for 
Did you mean: 
mendes094
Contributor III
Contributor III

Hide a value in a graphic

Hello, 

I have a graphic and I need to hide a value 'NE' in a bar chart:

 

mendes094_0-1733918666136.png

 

Anybody can help me? 

 

tks.

Labels (3)
1 Solution

Accepted Solutions
MatheusC
Specialist III
Specialist III

Hi, @mendes094 

Basically, this can be easily done by customizing the limitation > 0 graph, as in the screenshot below:

MatheusC_0-1733920303957.png

 

Did you find a solution to your question? Mark the solution as accepted ✅ and if you found it useful, press the like button!

View solution in original post

6 Replies
MatheusC
Specialist III
Specialist III

Hi, @mendes094 

Basically, this can be easily done by customizing the limitation > 0 graph, as in the screenshot below:

MatheusC_0-1733920303957.png

 

Did you find a solution to your question? Mark the solution as accepted ✅ and if you found it useful, press the like button!
NoahF
Contributor III
Contributor III

In addition, if you want to always exclude the NE value, even if it's >0.

Then you could use set analysis to exlude the specified value.

Sum({< Region -= {'NE'}>} Value)

This will always exlude 'NE', no matter the value.

 

Regards

mendes094
Contributor III
Contributor III
Author

Thanks, its work!

PaulVerkooijen_DataFix
Partner - Specialist II
Partner - Specialist II

Hi @mendes094 

Add-ons -> Data handling -> Disable: Include zero values

p_verkooijen_2-1733921065815.png

 

Excluding a specific dimension value is via Set Analysis like NoahF mentioned

Sum({< Region -= {'NE'}>} Value)
PaulVerkooijen_DataFix
Partner - Specialist II
Partner - Specialist II

@MatheusC 

This would prevent the barchart for showing any 0 or negative values.

Disabling: Include zero values would not have this side effect

p_verkooijen_0-1733921528998.png

 

MatheusC
Specialist III
Specialist III

@PaulVerkooijen_DataFix  That's right, already imagining this scenario this would certainly be a better approach.

Did you find a solution to your question? Mark the solution as accepted ✅ and if you found it useful, press the like button!