How to do a count of a word in a table

[#1]

Hello,

I am very new to QlikView and data analysis so please forgive me if I misspeak.

I have a large data set coming from SharePoint.  One of the tables contains multiple words ex, Pass, Fail, Not Tested and others.  I need to show on a bar chart the count of the word "Pass" and "Fail".  I have done some research but the best thing I can find is users doing an In Line Load of a paragraph in their load script and then counting the appearance of various letters and words and this is not applicable to my scenario.

Here is where I renamed the row to "Pass Fail"

ows_Pass_x002f_Fail as [Pass Fail],

I then added a bar chart and tried adding the below expression but it only gives me a count of 1 for each Dimension.  Maybe it isn't seeing [Pass Fail] as a row but just as a word?

SubStringCount('[Pass Fail]','Pass')

Any help is much appreciated.

Thanks - Jason

[swuehl · Accepted solution]

Jason, have you tried without the single quotes around the field name, like

SubStringCount( [Pass Fail] ,'Pass')

instead of

SubStringCount('[Pass Fail]','Pass')

[#3]

So I made that change and it does show Pass Fail in red now so I would imagine that is in fact referencing the row but it still only shows a count of 1.

[#4]

Actually that did it!!  I just re-did the chart and it gave me all the data I was looking for, I must have had something else in there stopping it.

Thank you very much for your help.