3 Replies Latest reply: Mar 20, 2016 1:20 PM by Gysbert Wassenaar RSS

    Filter bar Chart on Value Ranges

      Hello, I'm fairly new to qlik and I'm trying to do something that I think should be quite simple, but am having a bit of trouble.


      I'd like to filter bar chart values, using a range filter.


      The data I have is an average rate, the raw data has a range from 0 to about 1500.


      I want the bar chart to count(averageRate) grouped by product where the average rate is less than say 800.


      The SQL would look something like







           AverageRate < 800

      GROUP BY



      However I don't want to do this on the load script as I want to load all raw values, and have the user be able to select the range they are interested in looking at.


      I've tried creating a "master dimension" that looks something like if([averageRate] < 800, [averageRate]), but then my filter shows all values that are below 800.


      I thought one way of doing this would be to add another table in my DW something like DIM_Range that has an ID link to my fact table, but it seems like this would be a lot of work to do something that Qlik should be able to do on it's own.


      Thanks for any help!