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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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 II
Specialist II

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 II
Specialist II

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!

p_verkooijen
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)
p_verkooijen
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 II
Specialist II

@p_verkooijen  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!