2 Replies Latest reply: Feb 18, 2016 3:10 PM by Jesse Maitland RSS

    Bar Chart Time Sorting

    Jesse Maitland

      Hello,

       

      I am a new Qlik user, and am just starting in the world of analytics.

       

      I have a client that recently asked me to build a "Beat Rate" chart in Qlik. Apparently this type of chart comes from a Six Sigma methodology.

       

      I thought this kind of implementation would be simple, as basically it is just recreating a trend. The data recorded on a production line looks like this.

       

       

      My load script looks like this.

       

       

      Dead simple, 2 columns, one with a time stamp, one with a value. The above is a snip of sample data that I have manually generated, but the source data will by coming from an SQL query that looks the same as above.

       

      I want to use a bar chart that basically gives me the value for a given time stamp ordered by time ascending. However when I load the data into the Qlik Sense bar chart tool, I get this.

       

       

      All of the values are grouped together, with a bunch of leading zero records. They are not ordered numerically ascending by time.

      I've added time as a dimension and beat rate as a value.

       

      When I apply sorting options, it seems to only sort the label associated with the data, and not the order of the data itself.

      I want this bar chart to be sorted linearly by time. My sorting option look like this.

       

       

      This also doesn't make sense to me. If this bar graph is a representation of "sorting by load order" why would Qlik on the data import, first import all the 0 records, and then the records with values? This makes no logical sense.

       

      Thanks in advance for any help. I'm very new at this!

       

      Cheers,