Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to do a count of a word in a table


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

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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

SubStringCount( [Pass Fail] ,'Pass')


instead of


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

View solution in original post

3 Replies
swuehl
MVP
MVP

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

SubStringCount( [Pass Fail] ,'Pass')


instead of


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

Not applicable
Author


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.

Not applicable
Author


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.