topic Summation of null values in QlikView

Summation of null values

Thu, 26 Apr 2012 08:43:07 GMT

values

Is it possible to sum the above columns where '-' means null values, without using suppress null value condition?????

Summation of null values

Miguel_Angel_Baeyens — Thu, 26 Apr 2012 09:01:22 GMT

Hi,

You can use the Sum(values) expression. If those "-" are actual dash signs you better change them in the script to zeroes or nulls, but the Sum() should return correct values. If you cannot do that, use the following expression to exclude those "-" signs:

Sum({< values -= {'-'} >} values)

Hope that helps.

Miguel

Summation of null values

CELAMBARASAN — Thu, 26 Apr 2012 09:16:19 GMT

Hi,

What do you mean by summation of null values here?

Celambarasan

Summation of null values

Thu, 26 Apr 2012 09:20:55 GMT

Suppose i have sales column and it contains 10 rows,out which 4 rows does'nt have any values, it only shows dashes symbol '-'.......

Summation of null values

CELAMBARASAN — Thu, 26 Apr 2012 09:31:31 GMT

Hi,

Do you need to remove that rows?

Celambarasan

Summation of null values

kaushiknsolanki — Thu, 26 Apr 2012 09:31:40 GMT

Hi,

Try this

Count(if(isnull(Value),Value))

Regards,

Kaushik Solanki

Summation of null values

Thu, 26 Apr 2012 09:49:10 GMT

no,i just want the summation of that field

Re: Summation of null values

CELAMBARASAN — Thu, 26 Apr 2012 09:54:44 GMT

Hi,

You mean value is dimension and another field is expression.

You need to achieve sum(FieldName) for non null values?

Please explain little more briefer?

Celambarasan

Summation of null values

kaushiknsolanki — Thu, 26 Apr 2012 09:54:47 GMT

Hi,

I am Sorry I didnt understand what you want. Can you please explain in detail. If possible pls give one example

Regards,

Kaushik Solanki

Re: Summation of null values

Miguel_Angel_Baeyens — Thu, 26 Apr 2012 10:00:27 GMT

Did you try what I suggested above both just Sum() and Sum() with set analysis?