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: 
Darren1
Contributor III
Contributor III

Use set analysis to exclude NULL results in a KPI measure

I would like to use set analysis to exclude NULL results in a KPI measure. However when I use the scripts below it does not exclude the NULL results and displays the full "goal" total.  The "WIP.fips" is a string field. 

Sample script:

Sum({<[WIP.fips] = {'*'}>} [goal])

This is the full set analysis I am trying to create:

Sum({<[wip_bmp] = {'Cover Crop'}, [WIP.year] = {'2025'}, [type] = {'Agronomic'}, [WIP.county] = {'Allegany'}, [WIP.fips] = {'*'}>} [goal])

In my attached picture I would like to exclude the records with no value in the fips field (red mark). 

Thanks! 

1 Reply
brunobertels
Master
Master

hi may be one of this 

 

Sum({<[WIP.fips] = {'*'}-{''}>} [goal])

 

Sum({<[WIP.fips] = {"=not isnull([WIP.fips] )"}>} [goal])