How to do a count of a word in a table - Qlik Sense

[hammermill21]

Hello,

I have a table that has a few columns that have pass or fail, at the end, I want to have a final Pass/Fail Test column showing that if all the columns contain "pass" the full test Passes if not it fails.

I tried to count the pass or fails and that does not seem to work.  I also tried:

=count({<Your Dimension={'Pass','Fail'}>} Your Dimension) which didn't work either. To get the pass or fail for the "30%" column I have the function: =If([Actual Load Percentage] > 30, 'Pass', 'Fail') and for the "35 mins" pass or fail I have the following function: =If([Total Duration of Test] > 35, 'Pass', 'Fail')

Thank you!

[Anonymous]

Hi Elizabeth,

     Niclas's answer should work. If it is not check your syntax.

As an alternative can't you try if([Actual Load Percentage] > 30 and [Total Duration of Test] > 35, 'Pass', 'Fail').

If this also doesn't work try if([Actual Load Percentage] > '30' and [Total Duration of Test] > '35', 'Pass', 'Fail').

[hammermill21]

Ah! So easy!! I was making more complicated!! 

Thank you, it worked!!

[umartareen]

Okay.

This should help :

If([Actual Load Percentage] > 30 and [Total Duration of Test] > 35, 'Pass', 'Fail')

Where [Actual Load Percentage] and  [Total Duration of Test] should be the expressions of Column 3 and Column 7 respectively.

[hammermill21]

Thank you!!

[hammermill21]

And if I want to add another column to that?

Thank for all the help, at some point I will have this down packed!

[umartareen]

Then we may have to modify our expression accordingly.

[umartareen]

We will have to modify this way,

If([Actual Load Percentage] > 30 and [Total Duration of Test] > 35 and [Column New] > 'X', 'Pass', 'Fail')

[hammermill21]

I got it thank you.

[hammermill21]

Thank you for your help!