topic Re: Load statement exluding multiple values from another table in QlikView

Load statement exluding multiple values from another table

Anonymous — Mon, 12 Aug 2013 13:12:18 GMT

Hello to all. This problem really has me stumped. I have a table with one column in it. This column has about fifty rows, each with a different value. Basically, the table houses values that do not need to be selected. I want to be able to query in Qlikview, writing a statement that excludes any of the values from the first table. Is there a way to do this? I hope that I have explained this clearly enough. Thank you

Re: Load statement exluding multiple values from another table

er_mohit — Mon, 12 Aug 2013 13:17:49 GMT

yeah Supplose

ExcludingField has many value from1 to 100 ; i exclude 3 values like 40,50,13

so ,

you can write this way

load

FieldA,

FieldB,

FieldC,

ExcludingField

from Table

where wildmatch(ExcludingField<>'40','50','13');

if you want exclude one value like 40then try this way to write where condition

where ExcludingField<>'40';

hope it helps you

Re: Load statement exluding multiple values from another table

Gysbert_Wassenaar — Mon, 12 Aug 2013 13:19:31 GMT

Something using the exists function:

Table1:

Load A from somewhere;

Table2:

Load B,C,D from somewhereelse

where not exists(A,B); // meaning don't load the records where the value of B exists in field A in table1.

Re: Load statement exluding multiple values from another table

tresB — Mon, 12 Aug 2013 13:20:59 GMT

Try:

Load Field1 From firsttable;

Finaltable:

Load

Field1,

Field2,

....

From MainTbale Where Not Exists(Field1,Field1);

Re: Load statement exluding multiple values from another table

Anonymous — Mon, 12 Aug 2013 13:36:44 GMT

Thank you all so much for your quick answers. One last question, though. Is there a limit to how many values can be excluded? I have about 50 different values to exclude. Thanks again to all

Re: Load statement exluding multiple values from another table

Anonymous — Mon, 12 Aug 2013 13:37:02 GMT

Thank you all so much for your quick answers. One last question, though. Is there a limit to how many values can be excluded? I have about 50 different values to exclude. Thanks again to all

Re: Load statement exluding multiple values from another table

Anonymous — Mon, 12 Aug 2013 13:41:36 GMT

Thanks so much for your quick reply. To all, my only other question is.... is there a limit to how many values can be excluded? I have about 50 different values to exclude. That's why I wasn't sure if I could name the separate table in the select statement that houses that list of values. Thanks.

Re: Load statement exluding multiple values from another table

tresB — Mon, 12 Aug 2013 13:42:18 GMT

Without any limit, any number of records loaded in the first table will be excluded.