topic Dimension Aggregation Issue in QlikView

Dimension Aggregation Issue

Wed, 05 Feb 2014 22:12:59 GMT

I'm having an issue with a straight table.

I created "Date-Posted buckets" (Posted Month) and for 5/1/2013 it's not aggregating under the $'s Col. column. It seems to be related to more than 1 account qualifying for the bucket. All other buckets have a 1-to-1 relationship to the $'s Col. and # accounts that qualify. I'm not sure why this isn't aggregating.

Here, you'll such the relationship between account # and bucket. Any insights on why this is occuring? It should aggregate to $6,372.25. Thanks,

Re: Dimension Aggregation Issue

MK_QSL — Wed, 05 Feb 2014 22:16:31 GMT

can you post your sample file or apps?

Re: Dimension Aggregation Issue

Thu, 06 Feb 2014 20:50:35 GMT

Hi Brett, it be great to have a bit more info. If you are unable to post the app, as manish suggested, could you tell us more? eg What is the function in the $'s column?

I wonder, if it is because that is the day with more than 1 account attached to it, it is some aggregation issue in the function.

Erica