Discussion board where members can get started with Qlik Sense.
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.
But when i am individually doing it, i am getting the desired value.
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.
did u try
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.
No, even its not working.
its only showing the sum for 1 customers. not for all.
Can you please see the attached qvf