Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to filter records with specific words/numbers/etc. through the script/chart properties?

One of the dashboards I'm creating uses 'Job Name' as a dimension, but not all the job names are relevant to the report.

A particular instance of "Job Name" includes the job title and job code. For example, "Shipping Manager .C.85" or "Material Coordinator .B.11".

I want to filter out any result that has ".B.11" in the "Job Name" field from showing up in any charts, list boxes, tables, etc. Is there a way to do this through the script or chart properties?

Thank you

1 Solution

Accepted Solutions
MarcoWedel

at script also:

LOAD *

FROM tablename

Where not [Job Name] like '*.B.11*';


hope this helps


regards


Marco

View solution in original post

3 Replies
maxgro
MVP
MVP

in script

load

     *

from

     <yourfileortable>

where  not wildmatch([Job Name], '*.B.11*');

Not applicable
Author

Hi,

Try something like as below in the script.

If(Index([Job Name], 'B.11'> 0, 'B.11') as [Job Name]

hope it helps!!

MarcoWedel

at script also:

LOAD *

FROM tablename

Where not [Job Name] like '*.B.11*';


hope this helps


regards


Marco