Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sum of values including Null in Pivot Table

I have a Pivot Table with Null fields ( - ). I would like to return the sum for one year. The sum includes some null values.

pivotex.PNG.png

I have tried so far with

Sum({<[Year]='2011'>}[Revenue]))

and this returns 0 or None, so that there is some mishandling of the nulls apparently.

3 Replies
Gysbert_Wassenaar

Try Sum({<[Year]={'2011'}>}[Revenue])


talk is cheap, supply exceeds demand
Not applicable
Author

This does not make it

Gysbert_Wassenaar

Yes it does. It works perfectly here.


talk is cheap, supply exceeds demand