topic Re: How to Exclude field values in QlikView

How to Exclude field values

Fri, 17 Apr 2015 13:24:54 GMT

Hi All,

if i want to Exclude some of the Field values how do i solve that, maybe with the Like Function?

how do i take out all the Letta in my Table?

alexandros17 — Fri, 17 Apr 2015 13:28:32 GMT

Load * Where Wildmatch(Name, 'Letta') =0;

SELECT * from MyTable;

Let me know

Gysbert_Wassenaar — Fri, 17 Apr 2015 13:29:32 GMT

Where do you want to exclude them? In a front end chart or listbox or do you want to exclude them when you load the data?

In the load script you'd use the Wildmatch function:

LOAD

Name,

Surname,

Age

FROM ...

WHERE NOT Wildmatch(Name, '*Letta*');

Fri, 17 Apr 2015 13:30:44 GMT

Hi,

Thanks for Quick Response, i want to do it on my Front end

anat — Fri, 17 Apr 2015 13:30:54 GMT

alexandros17 — Fri, 17 Apr 2015 13:35:52 GMT

If Name is a dimension then:

Use edit and write : If(wildmatch(Name, 'Letta')>0, null(), Name) and check the box "Suppress null values"

awhitfield — Fri, 17 Apr 2015 14:41:16 GMT

Hi Thabiso,

Are you actually trying to remove the word 'Letta' from the name OR exclude names that contain the word 'Letta' ?

Andy