Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

To sum the spend by the distinct id

Hi,

I have a data like

uniqueidSpend
1$10
1$10
1$10
2$20
2$20

i wanted to sum up the spend by the distinct uniqueid Like

uniqueidSpend
1$10
2

$20

using set analysis in qlikview.can anyone help me in this?

Thanks.

1 Reply
MVP
MVP

To sum the spend by the distinct id

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.

Community Browser