Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

aggr () problem

hi,

  I have a problem with a field of "goal" that when placed in a simple table with selections of months, customer, product and branch, for example returns 84000.

But when I put him in a graph using a function sum () for the sum of all the months it returns in January ONLY 82908000 (84 000 would be right) the sum of all months is astronomical.

I am using this formula in the graphs:

sum (AGGR (BUDGET, Tax ID, BRANCH, PRODUCT, MONTH, YEAR, COMPANY))

I believe that the AGGR play the role of dimensions for the sums.

anyone have any idea why this happens

Thank you

2 Replies
Anonymous
Not applicable
Author

Sounds like you might have issues with your data model. Tables that are not connected and calculating something across those tables?

Impossible to say for sure without looking at the document

Not applicable
Author

It seems that the data model is not wrong, because when I search for tables and lists can reach values ​​in the spreadsheets of the data source.
The fact is that I get a function q I want to return a sum within
I do not know how can I pass the file to give you a look because the data is confidential UMSA company.
the budget spreadsheet data has the following dimensions
COMPANY
PRODUCT
CUSTOMER
BRANCH
MES
Based on these dimensions I think that a function always return to it would be summarized BUDGET oo "sum (AGGR (BUDGET, THE COMPANY, PRODUCT, CUSTOMER, BRANCH, MES))"
I am sure this thought?