topic Re: sum of Concat value in QlikView

sum of Concat value

priyarane — Mon, 12 Oct 2015 15:00:24 GMT

Hi Community,

I wanted to sum up the value from Conact function

Ex:=Concat(DEST_COLUMN,'|')

The value from Above function is = F_257555885_44

so now I wanted to sum above value ex: sum(F_257555885_44)

Now its cominng like sum(Concat(DEST_COLUMN,'|')) - this how can I execute

like aggr(sum(Concat(DEST_COLUMN,'|'))) - its error any way but I wanted sum up the value

Clever_Anjos — Mon, 12 Oct 2015 15:02:37 GMT

If your expression returns only one value

sum($(=Concat(DEST_COLUMN,'|')))

swuehl — Mon, 12 Oct 2015 15:04:16 GMT

You can't use an aggregation inside another aggregation, but more confusing, how do you want to sum F_257555885_44?

Is this a field name?

Maybe like this then

Sum( $(=Concat(DEST_COLUMN,'|') ) )