Skip to main content

New to Qlik Sense

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

Announcements
An issue has been identified on Qlik Cloud hub, please visit our Status Update Page for details: GET THE LATEST
cancel
Showing results for 
Search instead for 
Did you mean: 
hammermill21
Creator III
Creator III

Pass or Fail Based on Total

Hello,

I am calculating a percentage:

=Num([Actual Load Percentage]/100,'0%')

Which gives me 54%, now based on that I want to add a column showing PASS or FAIL. So if the percentage is over 30% it passes and if it's under 30% it Fails. I've tried a few ways and it doesn't seem to be working. 

Anyone have any suggestions?

Thank you!

1 Solution

Accepted Solutions
sunny_talwar

My bad, I forgot to add the if(

=If([Actual Load Percentage] > 30, 'Pass', 'Fail')

View solution in original post

10 Replies
cattersj
Contributor
Contributor

Can you duplicate the column, and wrap the statement in an IF statement.  Basically,

IF(Original Formula >30%, "Pass", "Fail")

sunny_talwar

should be just this

=[Actual Load Percentage] > 30, 'Pass', 'Fail')

hammermill21
Creator III
Creator III
Author

Hey SUnny,

I tried that but it gives me an error.

hammermill21
Creator III
Creator III
Author

Hi,

Yup tried that and also not working, getting an error.

sunny_talwar

Is this in a script or expression? Can you share a screenshot?

hammermill21
Creator III
Creator III
Author

I'm doing this as an expression.

sunny_talwar

screenshot?

hammermill21
Creator III
Creator III
Author

Sorry thought I attached it!Capture.JPG

sunny_talwar

My bad, I forgot to add the if(

=If([Actual Load Percentage] > 30, 'Pass', 'Fail')