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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
MishaM
Contributor II
Contributor II

Using a KPI visualization - How do I filter data so that only a count of results with a hyphen appear?

Hi,

I am working on a visualization and I need to use a KPI to show a count of the number of items where the "IncClose" has a value of "-". Could someone please help me do that?

 

Thank you!

Labels (1)
1 Reply
Sammy_AK
Creator II
Creator II

if IncClose value is a string, then you can use  count({<IncClose={'-'}>}IncClose)

if its a null value then use count(if(isnull(IncClose),1))