Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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
jsn
Honored Contributor

aggr () problem

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

aggr () problem

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?

Community Browser