I have a data like
i wanted to sum up the spend by the distinct uniqueid Like
using set analysis in qlikview.can anyone help me in this?
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.
Retrieving data ...