Help Needed in Line Chart

[#1]

Hi All,

I have attached one sample file for line chart...

In line chart, each line represents the each company..

I would like to show the one more line,that should be calculated value in yearwise...

it should show as like one more company...

that is all the companies should display as it is..one more line to show the Wt avg or avg of all the companies displayed in the chart..

Could anyone help me...

thanks in advance..

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/0218.Linechart.rar:550:0][View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/7723.Linechart.zip:550:0]

[johnw]

See attached for one approach. I added a new table with a new field that includes all companies plus 'Average'. These link back to the companies. My example is simpler than yours, but the expression is this:

if(CompanyWithAverage='Average'
,avg(total <Year> aggr(sum(Amount),Year,Company))
,sum(Amount))

So basically, it checks if this is supposed to be the average line, and if so, uses that expression. Otherwise it uses the normal expression.

I really hope there's a better solution, but some solution seems better than none.

[#3]

Hi John,

thanks for your reply....

I m not having only the companies....

I m having list of companies under list of industries under list of sector....

also i m going to apply the below formuala in the avg...

the below formula is for the companies....

sum(total <stockyear,CompanyName> $(=Parameter3))*sum(total <CompanyName> $(=Parameter1))/sum(total <CompanyName> $(=Parameter3))

for industry the general formula for sum is,

sum({$<Sector=,CompanyName=, Industries={$(vSubsector)}>} $(=Parameter3))

How to calculate the industry avg using the company avg formula...

[#4]

Hi John Witherspoon,

u have done the good job...

but i need some more help from you..

Leave that formula...

give me tha idea for the line chart..

i m not having only companies...

i have 30000 companies under different industries and sectors...

how to implement ur concept in that places...

could you pls help me...