Qlik Community

Ask a Question

New to Qlik Sense

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

Announcements
QlikWorld May 10-12, Online and Free! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bensomers
Contributor II
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
bensomers
Contributor II
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')

View solution in original post

2 Replies
Channa
Specialist III
Specialist III

try

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

Channa
bensomers
Contributor II
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')

View solution in original post