Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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])