topic Re: Line Chart not plot values in a days with multiple values in QlikView

Line Chart not plot values in a days with multiple values

wcamarg3 — Tue, 27 Oct 2020 20:11:48 GMT

Hi all,

I need a help. I'm trying to plot a line chart where the main dimension "X axis" is the date.

The issue that I'm facing is that the graph only plots the values on a day which had a single issue.

If the day had more than one issue, it doesn't plot the values on line chart.

I attached the screen for you to see.

If anyone knows to solve it please support.

Many thanks,

Wilson

Re: Line Chart not plot values in a days with multiple values

Nicole-Smith — Tue, 27 Oct 2020 21:52:42 GMT

Make sure the measure you are using on the line chart contains an aggregation function (i.e. sum, min, max, etc.)

Re: Line Chart not plot values in a days with multiple values

wcamarg3 — Wed, 28 Oct 2020 00:53:47 GMT

Thank you Nicole. If I use aggregation function it will appear values on the days, but it doesn't appear all individual values. I'm concerned on how to make appear the individual values.

Many thanks

Re: Line Chart not plot values in a days with multiple values

MayilVahanan — Wed, 28 Oct 2020 03:00:31 GMT

Hi @wcamarg3

If you are using Aggregation function, then it works for both individual values & multiple values also.

For ex:

Date as Dimension

Sum(Values) as Measure

Re: Line Chart not plot values in a days with multiple values

Nicole-Smith — Wed, 28 Oct 2020 14:54:34 GMT

For a line chart to display values, there can only be one measure value per dimension value. This is why an aggregation function is necessary on the measure to ensure there is only one value per the dimension. If you wanted to show every value, you would need a different dimension for each of them so there is only 1 dimension value to 1 measure value.

Re: Line Chart not plot values in a days with multiple values

wcamarg3 — Wed, 28 Oct 2020 15:40:32 GMT

Thank you Nicole. This is the solution that I came out.