Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

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

at script also:

LOAD *

FROM tablename

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


hope this helps


regards


Marco

3 Replies
MVP
MVP

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

in script

load

     *

from

     <yourfileortable>

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

Not applicable

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

Hi,

Try something like as below in the script.

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

hope it helps!!

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

at script also:

LOAD *

FROM tablename

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


hope this helps


regards


Marco

Community Browser