Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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
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.
Try:
Load Field1 From firsttable;
Finaltable:
Load
Field1,
Field2,
....
From MainTbale Where Not Exists(Field1,Field1);
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
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
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.
Without any limit, any number of records loaded in the first table will be excluded.