topic Help Needed in Line Chart in QlikView

Help Needed in Line Chart

Fri, 29 Oct 2010 10:57:21 GMT

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]

Help Needed in Line Chart

johnw — Fri, 29 Oct 2010 23:43:38 GMT

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.

Help Needed in Line Chart

Sat, 30 Oct 2010 06:35:12 GMT

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...

Help Needed in Line Chart

Sat, 30 Oct 2010 06:54:36 GMT

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...