topic Re: aggr problem in QlikView

aggr problem

Fri, 22 May 2015 14:40:58 GMT

Hi all,

I encounter a problem in using aggr. Hope someone can give me some help, much appreciate!

Here is the problem.

I had used below expression in the chart:

sum(aggr(sum(quantityTickets),MasterPID,packageIdCode))

It is with one of the dimension (Year-Month) and it shows incorrect value. However, when I used the same expression in other charts, it doesn't have problem. Moreover, when I selected either one of the month, the value will automatically be corrected. See below:

Before

After

Below is the linkage between the tables. The quantity is located in table colorsizes.

Please help and thanks for all your assistance and attention first!

Re: aggr problem

Clever_Anjos — Fri, 22 May 2015 15:56:10 GMT

sum(aggr(sum(quantityTickets),[Year-Month],MasterPID,packageIdCode))

Re: aggr problem

Sat, 23 May 2015 01:42:41 GMT

Oh! Thank you so much! It definitely resolved the problem! Would you please give me a little bit explanation of what the mistake I made to bring this problem in?

Re: aggr problem

Clever_Anjos — Sat, 23 May 2015 11:38:34 GMT

Every time you have an AGGR() inside an object that has dimensions, those dimensions should be into your expression, unless you know exactly what you are doing. (rare situations)

For example:

Your table has Year-Month as dimension, right? So, this field should be inside your AGGR() expression

Re: aggr problem

Sat, 23 May 2015 11:54:25 GMT

Got it! Thank you so much!

Re: aggr problem

Anonymous — Sat, 23 May 2015 19:15:16 GMT

Would you mind to close this discussion by marking Clever's answer as "correct"?

(Otherwise it is shown as "open" forever.)

Re: aggr problem

Sun, 24 May 2015 01:54:51 GMT

Sorry about that. I should have it done. Let me know if there is still any problem.