Line Chart - plot every result without aggregation

[Michael_Reese]

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.

[amit_saini]

Michael,

Please share your qvw

Thanks,

AS

[danieloberbilli]

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

[Michael_Reese]

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. 

[danieloberbilli]

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

[amit_saini]

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,

AS

[Michael_Reese]

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

[john_s_w_wood]

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.

[petter]

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.

[Michael_Reese]

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.