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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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