Isolating variables from a column

[#1]

Hey,

I am new to Qlikview and compeletely lost in writing expressions. I have two questions:

1.

I have a column titled "JobTItles" and a list of different jobs titles. I would like to count the amount of "Machine Operators" from that list of jobs. How can I do this?

I thought about using TextCount(), but how can I extract only the Machine Operators from the list? TextCount (JobTitles) gives me the number of all job titles.

2.

Also, how would I go abouts deselecting specific fields from a list, say if I wanted all but the Machine Operators?

Sorry for such a simple question, but I really can't find this in the obvious places, or maybe I am wording it wrong. Please help!

[tresesco]

1. SubStringCount()

2. Select one value-> Right click on that list box-> Select Excluded

[#3]

Hmm,  it does not show the "Machine Operator" on the list box, only JobTitle. I'm not sure how this works

[tresesco]

Could you post a sample qvw explaining the expected output there?

[#5]

try this

=count({<JobTItles={'Machine Operators'}>}Amount)

or

=sum({<JobTItles={'Machine Operators'}>}Amount)

[#6]

No worries!! I solved it it was the expression <> that excluded something form the list and <= that included only that thing. E.g. JobTitle <= 'Machine Operator' would only take in Machine Operators.