Can the average trendline be formatted to show the average %? As of now all I can get out of it is y=0.49 etc.
I have tried to make my own reference line, but cannot change the format either.
I also tried making a bar and line chart, and adding an average line as an expression. Yet when I attempt to change the number format of the line, it allows me to select percentage, but does not change the chart to reflect this.
If anyone runs into the same issue here taking averages of percentages, I have solved the issue:
1. You will need to calculate your own average using a reference line, only including the dimensions in your chart.
The average trendline generated by Qlikview only takes the averages of your % which is not acurate and is why I had the difference mentioned above.
2. To answer my original question: Copy and past your average equation into the label box of your reference line and check 'show label. Add the number format to your equation:
If anyone runs into the same issue here taking averages of percentages, I have solved the issue:
1. You will need to calculate your own average using a reference line, only including the dimensions in your chart.
The average trendline generated by Qlikview only takes the averages of your % which is not acurate and is why I had the difference mentioned above.
2. To answer my original question: Copy and past your average equation into the label box of your reference line and check 'show label. Add the number format to your equation:
