Discussion Board for collaboration on QlikView Scripting.
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?
Go to Solution.
at script also:
Where not [Job Name] like '*.B.11*';
hope this helps
where not wildmatch([Job Name], '*.B.11*');
Try something like as below in the script.
If(Index([Job Name], 'B.11'> 0, 'B.11') as [Job Name]
hope it helps!!