Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Sam_Thomas
Creator
Creator

Count only if another field's value is less than 1

Hi

Quite a simple one. 

I just want to create a KPI that displays the count of Stockpiles where the Tonnage isn't 0 (or Less than 1)

Example

StockpileTonnage
123
20
321
40
554
621

 

So the answer I'm looking for is 119.

Thanks in advance

Labels (4)
1 Reply
Taoufiq_Zarra

@Sam_Thomas 

=sum({<Tonnage={">0"}>}Tonnage)

Taoufiq_Zarra_0-1623322205030.png

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉