Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
sersal10
Creator
Creator

Sum(quantity) when province is null

Hi all,

I have 2 fields province and quantity, and need to find how much is the total quantity of the null provinces.

I am trying something like this but doesn´t work:

Sum({<province = {NULL}>} quantity)

or


Sum({<province={"=Len(province) = 0"}>} quantity)

 

Kind regards,

Sergio.

Labels (2)
11 Replies
sersal10
Creator
Creator
Author

I tried this and finally works. I think there is a much simpler way but it works 

Sum({<quantity ={"=Len(province) = 0"}>} quantity) - Sum({<province = {*} >} total quantity)

Many thanks

Clement15
Partner - Specialist
Partner - Specialist

Good if it works