topic Re: AGGREGATION PROBLEM in QlikView https://community.qlik.com/t5/QlikView/AGGREGATION-PROBLEM/m-p/1252526#M851520 <HTML><HEAD></HEAD><BODY><P>Hi... you were correct.</P><P></P><P>thanks</P></BODY></HTML> Wed, 08 Mar 2017 17:51:40 GMT silvia_assuncao 2017-03-08T17:51:40Z AGGREGATION PROBLEM https://community.qlik.com/t5/QlikView/AGGREGATION-PROBLEM/m-p/1252522#M851508 <HTML><HEAD></HEAD><BODY><P>I I have an aggreation problem, could you please help me understand how to solve it.</P><P></P><P></P><P><IMG alt="foto_qv.GIF" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/155628_foto_qv.GIF" style="height: 432px; width: 620px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/AGGREGATION-PROBLEM/m-p/1252522#M851508 silvia_assuncao 2020-11-25T16:16:04Z Re: AGGREGATION PROBLEM https://community.qlik.com/t5/QlikView/AGGREGATION-PROBLEM/m-p/1252523#M851511 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>If(Dimensionality() = 0,</STRONG></P><P><STRONG>Sum(Aggr(</STRONG></P><P></P><P><STRONG>(Sum({$&lt;[Account Expense as Country?] = {'1'}, Account_in_new_consolidation = {'Yes'} ,[Current year]={'Yes'},[Closing Period]={'$(=$(vMax_Closing_Period))'},[Company Code]={'Co-244','Co-627','Co-651','Co-653','Co-654','Co-659','Co-660','Co-445','Co-697','Regional'},[Corporate or LA]={'LA'} &gt;}([Estimates_Local_Currency])))</STRONG></P><P></P><P><STRONG>/</STRONG></P><P><STRONG>((Sum({$&lt;[Account Expense as Country?] = {'1'}, Account_in_new_consolidation = {'Yes'} ,[Current year]={'Yes'},[Closing Period]={'$(=$(vMax_Closing_Period))'},[Company Code]={'Co-244','Co-627','Co-651','Co-653','Co-654','Co-659','Co-660','Co-445','Co-697','Regional'},[Corporate or LA]={'LA'} &gt;}([AOP_Local Currency])))</STRONG></P><P><STRONG>/</STRONG></P><P><STRONG>(Sum({$&lt;[Account Expense as Country?] = {'1'}, Account_in_new_consolidation = {'Yes'} ,[Current year]={'Yes'},[Closing Period]={'$(=$(vMax_Closing_Period))'},[Company Code]={'Co-244','Co-627','Co-651','Co-653','Co-654','Co-659','Co-660','Co-445','Co-697','Regional'},[Corporate or LA]={'LA'} &gt;}([AOP])))</STRONG></P><P></P><P><STRONG>),[Company Name])),</STRONG></P><P></P><P><STRONG>(Sum({$&lt;[Account Expense as Country?] = {'1'}, Account_in_new_consolidation = {'Yes'} ,[Current year]={'Yes'},[Closing Period]={'$(=$(vMax_Closing_Period))'},[Company Code]={'Co-244','Co-627','Co-651','Co-653','Co-654','Co-659','Co-660','Co-445','Co-697','Regional'},[Corporate or LA]={'LA'} &gt;}([Estimates_Local_Currency])))</STRONG></P><P></P><P><STRONG>/</STRONG></P><P><STRONG>((Sum({$&lt;[Account Expense as Country?] = {'1'}, Account_in_new_consolidation = {'Yes'} ,[Current year]={'Yes'},[Closing Period]={'$(=$(vMax_Closing_Period))'},[Company Code]={'Co-244','Co-627','Co-651','Co-653','Co-654','Co-659','Co-660','Co-445','Co-697','Regional'},[Corporate or LA]={'LA'} &gt;}([AOP_Local Currency])))</STRONG></P><P><STRONG>/</STRONG></P><P><STRONG>(Sum({$&lt;[Account Expense as Country?] = {'1'}, Account_in_new_consolidation = {'Yes'} ,[Current year]={'Yes'},[Closing Period]={'$(=$(vMax_Closing_Period))'},[Company Code]={'Co-244','Co-627','Co-651','Co-653','Co-654','Co-659','Co-660','Co-445','Co-697','Regional'},[Corporate or LA]={'LA'} &gt;}([AOP])))))</STRONG></P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/155623_Capture.PNG" style="height: 467px; width: 620px;" /></P></BODY></HTML> Wed, 08 Mar 2017 13:58:49 GMT https://community.qlik.com/t5/QlikView/AGGREGATION-PROBLEM/m-p/1252523#M851511 sunny_talwar 2017-03-08T13:58:49Z Re: AGGREGATION PROBLEM https://community.qlik.com/t5/QlikView/AGGREGATION-PROBLEM/m-p/1252524#M851514 <HTML><HEAD></HEAD><BODY><P>but when If I open categories inside country, the total by category is not correct:</P><P>how can we fix it?</P><P><IMG alt="error 2.GIF" class="jive-image image-1" src="/legacyfs/online/155629_error 2.GIF" style="height: 224px; width: 620px;" /></P></BODY></HTML> Wed, 08 Mar 2017 14:12:21 GMT https://community.qlik.com/t5/QlikView/AGGREGATION-PROBLEM/m-p/1252524#M851514 silvia_assuncao 2017-03-08T14:12:21Z Re: AGGREGATION PROBLEM https://community.qlik.com/t5/QlikView/AGGREGATION-PROBLEM/m-p/1252525#M851517 <HTML><HEAD></HEAD><BODY><P>What do you expect to see instead when you expand?</P></BODY></HTML> Wed, 08 Mar 2017 14:17:04 GMT https://community.qlik.com/t5/QlikView/AGGREGATION-PROBLEM/m-p/1252525#M851517 sunny_talwar 2017-03-08T14:17:04Z Re: AGGREGATION PROBLEM https://community.qlik.com/t5/QlikView/AGGREGATION-PROBLEM/m-p/1252526#M851520 <HTML><HEAD></HEAD><BODY><P>Hi... you were correct.</P><P></P><P>thanks</P></BODY></HTML> Wed, 08 Mar 2017 17:51:40 GMT https://community.qlik.com/t5/QlikView/AGGREGATION-PROBLEM/m-p/1252526#M851520 silvia_assuncao 2017-03-08T17:51:40Z