Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

not in function..

Hi,

How to use Not in function in Qlik view

Example Query of Sql

select

Case when saleschannel='online' and userid not in ('MobileWap','Mobile APP')  then 'Online_Sales'

End Channel

from  temp_Table

Above Query How Can use in Qlik View ..

8 Replies
sushil353
Honored Contributor II

Re: not in function..

hi,

For NOT IN .. MATCH() is equivalent function in qlikview..

so you can use : Match(userid,'MobileWap','Mobile APP')

if (saleschannel='online' and Match(userid,'MobileWap','Mobile APP'), 'Online_Sales')

HTH

sushil

Not applicable

Re: not in function..

Like this

Load * from  temp_Table

Where saleschannel='online' and Match(userid,'MobileWap','Mobile APP') <=0;

Not applicable

Re: not in function..

how can use for the below Query

case when saleschannel='webdirect' and (userid null or userid not like '%MOBILE%')  then 'Online Channel'

end Channel

kalyan

Not applicable

Re: Re: not in function..

Load * From TempTable

Where saleschannel='webdirect' and (userid<>null() or Wildmatch(userid, '?MOBILE?') <=0);

arjunkrishnan
Contributor

Re: not in function..

Hai Kalyan ,

I Hope You This Will Most Helpful For Ur Understanding Concept of NOT IN How Working With Wild Match Concept..

Normal Table:

LOAD [Sno      ] ,

     [product ] ,

     Sales

FROM

sAD.xls

(biff, embedded labels, table is [Sheet1$]);

Wild Match(IN)

NoConcatenate

Table1_In_WildMatch:

LOAD [Sno      ] as Num,

     [product ] as Prod,

     Sales as Sales1

FROM

sAD.xls

(biff, embedded labels, table is [Sheet1$])

Where  WildMatch([product ],'P','Q');

WildMatch(NOT IN)

NoConcatenate

Table1_Not_In_WildMatch:

LOAD [Sno      ] as N_Sno,

     [product ] as N_Prod,

     Sales as N_Sales

FROM

sAD.xls

(biff, embedded labels, table is [Sheet1$])

Where not WildMatch([product ],'P','Q');

By

ArjunKrish

sivarajs
Valued Contributor II

Re: not in function..

load

If( saleschannel='online' and not match(userid,'MobileWap','Mobile APP')=-1,'Online_Sales') as Channel

from temp_Table

mangalsk
Contributor III

Re: not in function..

Hello,

load Online_Sales,saleschannel,userid

from table where  saleschannel='online' and not WildMatch(userid,'MobileWap','Mobile APP');

Not applicable

Re: not in function..

Hi,

It can be:

LOAD If(saleschannel='online' and Match(userid,'MobileWap','Mobile APP')=0,'Online_Sales') as Channel

From TempTable (or Resident TempTable)

Hope this helps.

Community Browser