Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
CostinelRO
Contributor
Contributor

Sum multiple columns and ignore nulls

I want to sum multiple columns and ignore the null values.

I added the columns in a table and it looks like this. To be achieved is what I want to obtain

NameSale1Sale2Sale3To be achieved
A53210
B7-411
C-516
D5--5

 

I tried to apply sum ( {<Plain ={"*"}>}Sale1) but this does gives different results.

Is there a way to sum like Sale1 + Sale2 + Sale3 and ignore the nulls?

Or maybe it's better to do this from the load?

Thanks in advance

Labels (2)
1 Solution

Accepted Solutions
Fernando_Fabregas

Hi ! You can use: 

Alt(Sale1,0) + Alt(Sale2,0) + Alt(Sale3,0)

Regards, Fernando

View solution in original post

1 Reply
Fernando_Fabregas

Hi ! You can use: 

Alt(Sale1,0) + Alt(Sale2,0) + Alt(Sale3,0)

Regards, Fernando

View solution in original post