Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2010-10-30 07:37 AM

could anyone findout the problem in the set analysis

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]

140 Views
0 Likes
0 Replies