Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

sum of different numbers

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?

1 Solution

Accepted Solutions
Not applicable

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

View solution in original post

5 Replies
Not applicable

Hey Fren,

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

CountryCitySales
USHouston5
USChicago5
MexicoMexico city10

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

Not applicable

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

Not applicable

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

View solution in original post

Not applicable

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

hope this helps

Not applicable

I can not remove them, I need the two dimensions