Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
tayariib85
Contributor II
Contributor II

Sum values including null values from other field

Hi Guys,

When I sum Col1 I get 70 instead of 100, it seems that (-) in Col2 not included in the sum. How can I force Col1 to sum all including ?

tayariib85_1-1670589523711.png

Thank you 

Labels (4)
1 Reply
agigliotti
Partner - Champion
Partner - Champion

Hi @tayariib85 ,

The sum of Col1 is 150.
Is Col2 a dimension and Col1 an expression as Sum(Col1) ?