Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ..
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
Like this
Load * from temp_Table
Where saleschannel='online' and Match(userid,'MobileWap','Mobile APP') <=0;
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
Load * From TempTable
Where saleschannel='webdirect' and (userid<>null() or Wildmatch(userid, '?MOBILE?') <=0);
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
load
If( saleschannel='online' and not match(userid,'MobileWap','Mobile APP')=-1,'Online_Sales') as Channel
from temp_Table
Hello,
load Online_Sales,saleschannel,userid
from table where saleschannel='online' and not WildMatch(userid,'MobileWap','Mobile APP');
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.