Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Issue in sum in a concatenate table

Hi,

Please find attached the qvf and data set.

I have a concatenate table, and trying to get the sum for all column as below.

but its showing as zero.

sum(Activity1+Activity2+Activity3+Pcost+Tcost)

But when i am individually doing it, i am getting the desired value.

sum(Activity1)+sum(Activity2)+sum(Activity3)+sum(Pcost)+sum(Tcost)


Can you please help me to understand the difference.


For set analysis, i would required the expression 1, but it will be difficult to apply the set analysis in 2nd expression.


Can you please help me on this.


Thanks

Prasanta

3 Replies
sureshqv
Esteemed Contributor III

Re: Issue in sum in a concatenate table

did u try

=Sum(column1,column2,colum3,pcost,cost)

MVP
MVP

Re: Issue in sum in a concatenate table

Try this as well:

RangeSum(Activity1, Activity2, Activity3, Pcost, Tcost)

The issue is related to Summing of Null Values. If one of those values are Null, then Sum doesn't know how to handle it.

Not applicable

Re: Issue in sum in a concatenate table

No, even its not working.

its only showing the sum for 1 customers. not for all.

Can you please see the attached qvf