not in function..

[#1]

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 ..

[sushil353]

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

[#3]

Like this

Load * from  temp_Table

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

[#4]

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

[#5]

Load * From TempTable

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

[arjunkrishnan]

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]

load

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

from temp_Table

[mangalsk]

Hello,

load Online_Sales,saleschannel,userid

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

[#9]

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.