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

    Filter bar Chart on Value Ranges

    Jesse Maitland

      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

       

      SELECT

           Count(averageRate)

      FROM

           TableA

      WHERE

           AverageRate < 800

      GROUP BY

           ProductID;

       

      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!

       

      Jesse