This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
Hi all member ,i have this table in excel
i want to load Task that doesn't have an 'X' Type the result like
how i do that please
where where upper(Type)='X'
where not exists (Task)
drop table tmp;
LOAD Task as Exclude
WHERE Type = 'X';
LOAD Task, Type
WHERE NOT EXISTS(Exclude, Task);
Where Type <> 'X'
to your load statement at the end
Type from datasource where Type <> 'X' and Type<> 'x';
try like this...
FROM Test.xlsx (ooxml, embedded labels, table is Sheet1)
where not WildMatch(Task&Type,'*X*');
Load * from tablename where Type <>'X'