sum of different numbers

[#1]

good afternoon, my situation is this, I have 2 records with a value of 5, as I do so that the sum of the two registers is equal to 10 and not 5?

[#2]

Hey Fren,

There might be other distinct dimensions to it in that same table

Country	City	Sales
US	Houston	5
US	Chicago	5
Mexico	Mexico city	10

So when you sum by Country as dimension you will get 10.

[#3]

Thank's mi situation is this, the only different dimension is user num, category is the same an the value is 5

ie:

user num     category    value

1                   1                     5

2                    1                    5

the result should be 10, but qlik show 5

[#4 · Accepted solution]

You can do sum(aggr(sum(Distinct Value),category))

[#5]

REmove user num by table and use sum(value) as expression and only category as dimension.

hope this helps

[#6]

I can not remove them, I need the two dimensions