topic Aggr Sum not working with Multiple values in QlikView

Aggr Sum not working with Multiple values

Tue, 30 Mar 2010 09:44:49 GMT

Hi all,

I create a variable contains the following formula:

aggr(sum(sales),country)

And I created a straight table showing <country> and <sales per country> by using the above variable. It works fine when I only choose 1 country. But when I select multiple countries in my report, value of this value becomes '-' for all the selected countries in the straight table.

Can someone give me a hand on this? Thanks.

Aggr Sum not working with Multiple values

Tue, 30 Mar 2010 12:56:26 GMT

Why do you use aggr if you have <country> in your straigt table?
sum(sales) should work just fine.

/Fredrik

Aggr Sum not working with Multiple values

ssamuels — Tue, 30 Mar 2010 19:15:02 GMT

Hi,

Try using the NODISTINCT option when using the AGGR function:

AGGR(NODISTINCT sum(sales), country)

With the use of the NODISTINCT option the AGGR function will return multiple values.

---
Steven

Aggr Sum not working with Multiple values

Wed, 31 Mar 2010 02:04:46 GMT

Hi Fredrik,

Actually, there are some other dimensions on my straight table and I need to set the background color according to the sum of sales by country.

I'm new to Qlikview, and I feel unsave to use sum(sales) instead of aggr because I don't know which level (dimension) Qlikview is grouping the data by. Is there any way I can ensure the sum is always by country level if I use sum(sales)? Thanks.

Regards,
Lewis

Aggr Sum not working with Multiple values

Wed, 31 Mar 2010 02:09:14 GMT

Hi Steven,

I tried AGGR(NODISTINCT sum(sales), country), but it's not working. Actually, all the rows in my striaght table are already grouped by country and they should be distinct values already. Is there anything else I should check? Thanks.

Regards,
Lewis

Aggr Sum not working with Multiple values

Wed, 31 Mar 2010 08:13:49 GMT

Hi Lewis

Any chance you can post an exemple application. That would probably give you a solution quickly 😉

/Fredrik

Aggr Sum not working with Multiple values

Wed, 31 Mar 2010 08:50:05 GMT

Hi Fredrik,

Please find the attached file for a simplied version of my report. In this report, if you pick only 1 "TR", the value of variable - "V1" would be shown properly. However, if you select multiple values for "TR", the value of "V1" shown as "-" for all the selected rows in the straight table. Please let me know if you have any idea on how to fix this problem. Thanks a lot for your help.

Regards,
Lewis

Aggr Sum not working with Multiple values

Wed, 31 Mar 2010 14:34:46 GMT

See the attached file. Minor changes but oh so important...

regards
/Fredrik

Aggr Sum not working with Multiple values

Thu, 01 Apr 2010 04:04:06 GMT

Hi Fredrik,

It is exactly what I need, thanks a lot for your help.

Regards,

Lewis

Re: Aggr Sum not working with Multiple values

Nitish91 — Thu, 14 Sep 2023 08:46:06 GMT

Thanks! This saved me.