Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This is my source data:
Order ID | Value A | Value B |
---|---|---|
A | 2 | 6 |
B | 5 | 4 |
B | 5 | 2 |
C | 1 | 5 |
C | 1 | 5 |
C | 1 | 4 |
D | 6 | 8 |
I want my result table in Qlik Sense to be:
Order ID | Distinct Sum Value A | SUM Value B |
---|---|---|
A | 2 | 6 |
B | 5 | 6 |
C | 1 | 14 |
D | 6 | 8 |
Total | 14 | 34 |
I tried everything with Aggr, Distinct and Sum, but haven't succeeded yet. Who can point me in the right direction? I would be very grateful!
Thanks, unfortunately in the complete dataset, values are not always unique. See above my comments to Sunny for more details.
May be use Dimensionality() function here:
The second dimension... or how to use secondarydimensionality()