Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
1. SubStringCount()
2. Select one value-> Right click on that list box-> Select Excluded
Hmm, it does not show the "Machine Operator" on the list box, only JobTitle. I'm not sure how this works
Could you post a sample qvw explaining the expected output there?
try this
=count({<JobTItles={'Machine Operators'}>}Amount)
or
=sum({<JobTItles={'Machine Operators'}>}Amount)
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.