# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for
Did you mean:
Contributor II

## if result of count - Combing num and count with if

If someone could please help with this.. Should be fairly straightforward but I am obviously missing something obvious.

I have a collumn of data that is either Yes or No. If the percentage of Yes is higher than 98.00% I would like to return "SLA Met".

I have managed to return the percentage of Yes using:

=Num(Count({<SLAMet= {'Yes'}><slamet= {'yes'}="">} SLAMet)/Count(SLAMet), '#,##0.00%')</slamet=>

But I can't seem to figure out how to add 'if above 98.00%, return "SLA Met"'

Any suggestions?

1 Solution

Accepted Solutions
Contributor II
Author

Thank you Channa.

I had to tweak it slightly to get it to work but you gave me the foundations to figure it out. Really appreciate it!

This is the adjusted expression that worked:

=IF(Count({<SLAMet= {'Yes'}>} SLAMet)/Count(SLAMet)>.98,'meat','non')

2 Replies
Specialist III

try

IF(Count({<SLAMet= {'Yes'}><slamet= {'yes'}="">} SLAMet)/Count(SLAMet)>.98,'meat','non')

Channa
Contributor II
Author

Thank you Channa.

I had to tweak it slightly to get it to work but you gave me the foundations to figure it out. Really appreciate it!

This is the adjusted expression that worked:

=IF(Count({<SLAMet= {'Yes'}>} SLAMet)/Count(SLAMet)>.98,'meat','non')