Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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)
4 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? 

fabian3684386
Contributor III
Contributor III

i still found no anwer to this issue, did anyone get this running?