topic Re: Trendline by % in QlikView

Trendline by %

Anonymous — Tue, 11 Jun 2013 20:32:05 GMT

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!

Re: Trendline by %

sujeetsingh — Wed, 12 Jun 2013 04:15:50 GMT

See this sample may it help you

Re: Trendline by %

Anonymous — Thu, 13 Jun 2013 17:11:27 GMT

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%

Re: Trendline by %

Anonymous — Thu, 13 Jun 2013 17:47:38 GMT

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%')