Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.
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.
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.