topic Re: Add the average line to a line chart with multiple lines Qlik Sense in App Development

Add the average line to a line chart with multiple lines Qlik Sense

prakashsonti — Tue, 09 Apr 2019 16:49:34 GMT

This question is about creating a "Average" line in a line graph that has multiple lines.

There has been a recommendation in the "QlikView" threads that meets my needs but does not work in QlikSense. I am wondering if there is an alternate implementation.

Attached image shows what I want to achieve and the problems.

Attached QlikSense file is a sample and also attached Excel file with sample data.

Re: Add the average line to a line chart with multiple lines Qlik Sense

sunny_talwar — Tue, 09 Apr 2019 17:46:03 GMT

Check attached

Script

[Sheet1]:
LOAD
	[Date],
	[State],
	[Revenue]
 FROM [lib://AverageLinewithMultipleLines/AverageLineDataSet.xlsx]
(ooxml, embedded labels, table is Sheet1);

Dim:
LOAD * INLINE [
Dim
1
2
];

Chart

Dimension

Date
=Pick(Dim, State, 'Average')

Expression

=Avg([Revenue])

Re: Add the average line to a line chart with multiple lines Qlik Sense

prakashsonti — Tue, 09 Apr 2019 17:57:32 GMT

Thanks for the quick reply. This works great!