Trendline by %

[Anonymous]

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.

Any help is appreciated.

Thanks!

[sujeetsingh]

See this sample may it help you

[Anonymous]

Hi Ek,

Attached is an example of the average calculated using a reference line.  You will see that the value is different than the actual average.

Average trendline = red ~19%

Reference Line = Green ~7%

[Anonymous · Accepted solution]

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:

=num(AVERAGE EQN,'#,##0.00%')