I think the line chart is not showing data that has multiple y values for one x value. I am not able to find any help on this subject.
Here is my problem. I have data that I need to show on a line chart instead of a scatter chart, but when I change from a scatter chart to a line chart, not all of the data is showing (See image. The top is the scatter chart and the bottom plot is the line chart)
Here is what I have done so far in the chart properties dialog window:
I have "Show All Values" checked in the dimensions tab
I have the "continuous" x axis checked in the Axes tab
I have two dimensions and one expression. The first dimensions is called "Target". The second dimension is a unique identifier for each row of data. The expression is called "Actual"
>>I think the line chart is not showing data that has multiple y values for one x value...
That is correct. When you use a naked* field name like 'Actual' and there is more than one possible value Qlik cannot determine which value you want. You need to use an aggregation value like Sum(), Avg() or Max() to handle multiple possible values.
* a naked field is a field in an expression/measure without any aggregation function. Qlik treats these in expressions/measures as if they were enclosed in Only(). Read up on the Only() function in the online help.
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
>>I think the line chart is not showing data that has multiple y values for one x value...
That is correct. When you use a naked* field name like 'Actual' and there is more than one possible value Qlik cannot determine which value you want. You need to use an aggregation value like Sum(), Avg() or Max() to handle multiple possible values.
* a naked field is a field in an expression/measure without any aggregation function. Qlik treats these in expressions/measures as if they were enclosed in Only(). Read up on the Only() function in the online help.
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
