Filtering on a histogram

[ammarahw]

Is it possible for to filter on a histogram in Qlik? When I select histogram as my chart type I stop seeing filtering as an option but I would like to remove several outliers that would be possible to remove if I could filter on a range for the data which is normally simple to do. 

[Lisa_P]

You can go in and manually filter on the Y axis to limit the frequency axis to only select ranges above a certain value with drag. To eliminate all zeros, just create a bar chart.

[ammarahw]

Thank you for this response! What do you mean by manually filter on the Y-axis? Is there somewhere where I can write a filter expression and add it? I think a screenshot of what you are talking about may help. 

[marcus_sommer · Accepted solution]

Instead of filtering unwanted dimension-values you may consider to limit the values from the outlier, like:

if(Expr < -1, -1, if Expr > 1, 1, Expr))

for a scenario in which histogram shows results from -100% to 100% which moved the outliers to the left and right borders of the chart. I use it in this way and think the general approach might be adaptable for many scenarios.