1 Reply Latest reply: Jun 15, 2011 5:08 PM by Trent Jones RSS

    First time Qliker, Trying to create a line chart

      I'm trying to create a line chart (basically the graphs on sheet 2 of the attached excel file). As you cans see in the pivot table I am trying to look at the number of occurances (y-axis) where the rate of production is between intervals like 0-10%, 10-20% and so on... Does my expression have to be wrriten using RangeCount or am I just totally off track here? I attached what I have so far.

       

       

       

      (how do I write an expression that says how many # of occurances occurs in a data set range(from 0%-500%, with 10% intervals by example)