Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
firmographs
Partner - Contributor III
Partner - Contributor III

box plot handling of null and zero values

We are using box plots to look at a small (700 value) dataset.  

We want to exclude values that are either null or zero.  

What is the best way to achieve this?  

Labels (2)
3 Replies
Kirsten
Creator II
Creator II

Usually you can just under data when you click on the dimension or measure, just unselect "include Null Values" 

See attachment

firmographs
Partner - Contributor III
Partner - Contributor III
Author

This does usually work, but in this case, is not working.  Although our dataset does not have zero measure values for all dimensions, all of the box plot whiskers start a zero.  I believe this may be a known issue, and may require a sort of sophisticated set analysis workaround.  

derrickshaw
Contributor II
Contributor II

I have this same issue. Does anyone have an answer?