Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

load values

Hi all member ,i have this table in excel

Task

Type

T1

B

T1

X

T2

B

T2

C

T3

D

T3

X

T4C

i want to load Task that doesn't have  an 'X' Type the result like

T2

T4

how i do that please

thanks

6 Replies
Anonymous
Not applicable
Author

tmp:

load Task

where where upper(Type)='X'

Final:

load Task,

Type

from ..

where not exists (Task)

drop table tmp;

swuehl
MVP
MVP

LOAD Task as Exclude

FROM Excel.xls

WHERE Type = 'X';

LOAD Task, Type

FROM Excel.xls

WHERE NOT EXISTS(Exclude, Task);

NareshGuntur
Partner
Partner

Add

Where Type <> 'X'

to your load statement at the end

sunilkumarqv
Specialist II
Specialist II

Load

Task,

Type from datasource where Type <> 'X' and Type<> 'x';

PradeepReddy
Specialist II
Specialist II

try like this...

LOAD Task,

     Type

FROM Test.xlsx (ooxml, embedded labels, table is Sheet1)

where not WildMatch(Task&Type,'*X*');

balrajahlawat
Champion
Champion

Load * from tablename where Type <>'X'