topic Line Chart - plot every result without aggregation in QlikView

Line Chart - plot every result without aggregation

Michael_Reese — Wed, 27 May 2015 04:59:29 GMT

It seems like it should be simple. I must be missing something.

I want to plot every result over time so i can show which ones fall out of bounds of the upper and lower control limits.

It works if I show it in a table even when hiding the unique id. However, fast change to the line chart still averages over results that occurred at the same time.

Re: Line Chart - plot every result without aggregation

amit_saini — Wed, 27 May 2015 05:08:44 GMT

Michael,

Please share your qvw

Thanks,

Re: Line Chart - plot every result without aggregation

danieloberbilli — Wed, 27 May 2015 05:34:44 GMT

maybe you have too many dimensions in the straight table...the chart types are most times limited to 2-3 dimensions

Re: Line Chart - plot every result without aggregation

Michael_Reese — Wed, 27 May 2015 05:37:31 GMT

The issue is when I show it as a line chart. it works fine as a straight table.

To be clear, the line chart needs to plot every value even if there are multiple results at the same time.

Re: Line Chart - plot every result without aggregation

danieloberbilli — Wed, 27 May 2015 05:41:10 GMT

e.g. if you have 5 dimensions in the straight table and use fast change, it will keep the 5 dimensions and the chart will not show the right results as the chart type cant deal with the amount of dimensions

Re: Line Chart - plot every result without aggregation

amit_saini — Wed, 27 May 2015 05:43:00 GMT

Hi,

I think this is not possible with line chart to plot every single value. Could be possible with table box , straight table etc.

Also might help u:

https://community.qlik.com/message/730944#730944

Thanks,

Re: Line Chart - plot every result without aggregation

Michael_Reese — Wed, 27 May 2015 05:43:56 GMT

The line chart needs to plot all results. If it can be done with one dimension, that's fine. Nothing is working.

Re: Line Chart - plot every result without aggregation

john_s_w_wood — Wed, 27 May 2015 08:26:45 GMT

Do you have a dimension which uniquely identifies each record e.g. Transaction No or ID? Using this as the dimension should show a line for every record.

Re: Line Chart - plot every result without aggregation

petter — Wed, 27 May 2015 09:55:29 GMT

Your Line Chart is not actually averaging where you have multiple values. It simply ignores multiple values and draws a line between the two adjacent points.That is an average of the two adjacent points not an average of the multiple values - unless they happen to coincide.

I think Line Chart is not the right choice of Chart Object for you. Maybe the scatter chart would work better for you. You can get the scatter chart - which is X,Y oriented to actually draw lines however you want if you supply the right values in the right dimensions and expressions.

Re: Line Chart - plot every result without aggregation

Michael_Reese — Wed, 27 May 2015 16:01:57 GMT

Yes, I have time and transaction id as the dimensions. Transaction id doesn't display. The expression is avg(result) so it averages over time.

Re: Line Chart - plot every result without aggregation

Michael_Reese — Wed, 27 May 2015 16:06:05 GMT

It's definitely averaging. No values are being ignored.

I have an out of bounds value that was not rendering in the 12:01 time slot.I had no values that matched what was being displayed. When I toggled to a straight table, I could see the 5 values separately from 12:01. It was then clear they were being averaged as one in the line chart (even though transaction id is a secondary dimension).

I'll try the scatter, but the request is to show a trending line chart over time with upper and lower control limits to identify the outliers.

Re: Line Chart - plot every result without aggregation

rwunderlich — Wed, 27 May 2015 21:07:42 GMT

It would be helpful if you could post a qvw.

Re: Line Chart - plot every result without aggregation

Michael_Reese — Thu, 28 May 2015 05:04:22 GMT

I was able to correct the issue by moving the UCL, LCL and Median to reference lines. This allowed the IDs to plot individually. It was necessary to set them as separate expressions. That was throwing everything off.