Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
You can do sum(aggr(sum(Distinct Value),category))
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.
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
You can do sum(aggr(sum(Distinct Value),category))
REmove user num by table and use sum(value) as expression and only category as dimension.
hope this helps
I can not remove them, I need the two dimensions