Hi all
I m using the following expression in the line chart to display the wt.avg value..
=sum(total <CashYear> aggr(sum(total <CashYear, CompanyName> NetCashFlowOperatingActivity)*sum(total <CompanyName> Depreciation)/sum(total <CompanyName> ProfitBeforeTax),CashYear, CompanyName) )/sum(NetCashFlowOperatingActivity)
Wen i select the years like 2007 to 2009 at the time the values r not coming perfectly...
wen i select one year the value shows perfectly...
could anyone help me where i made mistake....[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/4073.setanalysis.zip:550:0]
here i attached the sample file, [View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/8270.setanalysis.rar:550:0]