Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a data like
uniqueid | Spend |
1 | $10 |
1 | $10 |
1 | $10 |
2 | $20 |
2 | $20 |
i wanted to sum up the spend by the distinct uniqueid Like
uniqueid | Spend |
1 | $10 |
2 | $20 |
using set analysis in qlikview.can anyone help me in this?
Thanks.
To get the chart you've indicated is as simple as making a table box with uniqueid and Spend as fields. You don't need expressions or set analysis. If that's not what you want, you'll need to explain your problem better.