Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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))