Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Master II
Master II

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
Author

Like this

Load * from  temp_Table

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

Not applicable
Author

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
Author

Load * From TempTable

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

arjunkrishnan
Partner - Creator II
Partner - Creator II

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
Specialist II
Specialist II

load

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

from temp_Table

mangalsk
Creator III
Creator III

Hello,

load Online_Sales,saleschannel,userid

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

Not applicable
Author

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.