topic aggr () problem in QlikView

aggr () problem

Wed, 22 Jun 2011 21:58:18 GMT

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

aggr () problem

Anonymous — Thu, 23 Jun 2011 00:00:53 GMT

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

aggr () problem

Thu, 23 Jun 2011 13:51:05 GMT

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?