topic To sum the spend by the distinct id in QlikView

To sum the spend by the distinct id

Thu, 23 Jun 2011 16:42:31 GMT

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 sum the spend by the distinct id

johnw — Thu, 23 Jun 2011 18:38:43 GMT

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.