topic Re: Filters Issue in QlikView

Filters Issue

renjithpl — Tue, 06 Aug 2013 06:09:40 GMT

Hi All,

I need a clarification,

I have used where condition to filter few things, my code looks like below

... where not exists(Exclude, FieldName) and Field2 <> 0;

when i use this, my exists function not working as i want.

Can we use AND mode after we use not exists function.?

Regards

Ren

Re: Filters Issue

dmohanty — Tue, 06 Aug 2013 06:17:57 GMT

Hi,

Plz post the script to look at. Will help to analyze.

Re: Filters Issue

Anonymous — Tue, 06 Aug 2013 06:18:02 GMT

Yes, you can. Can you post the rest of the code, so we can see how your Exclude field is set up and what values are coming in on the load statement.

Jonathan

Re: Filters Issue

renjithpl — Tue, 06 Aug 2013 06:29:49 GMT

Actually, you are right, we can use AND after exists, I realised the problem. As i wanted to exclude few countries from Country field, as country is the primary key, and loading from different sources. I have filtered only in one source. Thanks anyways for the quick response. Cheers !