topic Re: Isolating variables from a column in QlikView

Isolating variables from a column

Fri, 20 Nov 2020 18:02:30 GMT

Hey,

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

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.

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!

Re: Isolating variables from a column

tresB — Thu, 30 Jan 2014 09:33:47 GMT

1. SubStringCount()

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

Re: Isolating variables from a column

Thu, 30 Jan 2014 10:10:07 GMT

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

Re: Isolating variables from a column

tresB — Thu, 30 Jan 2014 10:16:42 GMT

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

Re: Isolating variables from a column

Thu, 30 Jan 2014 10:24:13 GMT

try this

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

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

Re: Isolating variables from a column

Thu, 30 Jan 2014 16:25:50 GMT

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.