Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Summation of null values

values

1

2

3

4

5

6

-

-

-

-

10

15

16

-

-

-

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

9 Replies
Miguel_Angel_Baeyens

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

CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     What do you mean by summation of null values here?

Celambarasan

Not applicable
Author

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

CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     Do you need to remove that rows?

Celambarasan

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

     Try this

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

Regards,

Kaushik Solanki 

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Not applicable
Author

no,i just want the summation of that field

CELAMBARASAN
Partner - Champion
Partner - Champion

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

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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   

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Miguel_Angel_Baeyens

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