Showing all data points on a line graph regardless of the dimension

[jcazzato]

Hi everyone,

We are having some trouble creating a graph without averaging out the data points.

We have the date as the dimension but within the date there could be up to 12 data points, and the graphs just averages the points into 1.

This is an example of the "formula" we are using

Avg({<[CHECK_LOCATION_NAME]={'Roughing Mill - Stand 6H'},[QUESTION_NAME]={'Check DENCO oval gears - 1'}>}[VALUE_FINAL])

I know we are using the AVG function but we cant find another way to do it

Any help would be greatly appreitated

Thanks,

Jo

[JordyWegman]

Hi Jo,

Is it possible that your set analysis is excluding all this information and you are left with only one point?

What if you delete all this set analysis, do you get your 12 points? If not, is your data even connected to these 12 points?

Jordy

Climber

[marcus_malinow · Accepted solution]

Qlik will aggregate your data together to create a single data point per each of your dimension values. So, if you want multiple values for a particular dimension value, you'll need to add a second dimension with the aim of creating a single value per combination of two dimensions

For example with this source data

Date	Value
1/1	10
1/1	20

This would result in a single average value of 15 for 1/1

By adding another dimension

Date	Second Dimension	Value
1/1	A	10
1/1	B	20

This would result in two values being shown