Discussion board where members can get started with QlikView.
I am trying to understand the following functions
Load * INLINE [
ID, Name, Dept
Assume now i have loaded this table "Table1"
I would require to create another table from 'table1' where the field "name" has the letter 'b' or letter 'c'
## This works##
ID as newID,
Name as newname,
Dept as newdept
Name like ('*a*')
## THIS DOESNT WORKS##
Name like ('*a*', '*c*')
If i need to search for both 'a' and 'c', then what is that i should be using?
How to use Match, Mixmatch and Wildmatch with the following example instead of like.
Can someone please help me in understanding this.
all the function were demostrated with small examples
in simple terms:
Match is use insted of writing multiple where conditions or if conditions
where product='a' and product ='b' and product='c';
by using match we can write like
in the same way
wild match is to use match with wild characters %
and mix match is case insensitive
and like is instead of multiple where its same as match.