Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I'm new to qlikview and I don't know how to translate this oracle query into qlikview query. Can someone please help me to translate this query or give me an explanation regarding IN at qlikview?
Oracle Query :
CASE
WHEN TRAN_TYPE IN
('COS', 'ICO', 'ISI', 'ISS', 'IST', 'RSI', 'FAO')
THEN
TRAN_AMOUNT
ELSE
0
END
You can use as below
IF(Match(TRAN_TYPE,'COS', 'ICO', 'ISI', 'ISS', 'IST', 'RSI', 'FAO'),TRAN_AMOUNT,0)
You can use as below
IF(Match(TRAN_TYPE,'COS', 'ICO', 'ISI', 'ISS', 'IST', 'RSI', 'FAO'),TRAN_AMOUNT,0)
Hi
I was just posting this to you
LOAD TranId, Tran_type, TRAN_AMOUNT Inline [
TranId, Tran_type, TRAN_AMOUNT
1, COS, 500
2, ICO, 300
3, IST, 200
4, none, 400
5, none, 150
];
T2:
Load TranId,
Tran_type,
if (Match(Tran_type, 'COS', 'ICO', 'ISI', 'ISS', 'IST', 'RSI', 'FAO'), TRAN_AMOUNT, 0) as newAmount
Resident T1;
drop Table T1;
Hi,
You can use wildmatch() also.
Like
if(wildmatch(TRAN_TYPE,'COS', 'ICO', 'ISI', 'ISS', 'IST', 'RSI', 'FAO'),TRAN_AMOUNT,0)
wildmatch() is incase sensitive function where as match() function is case sensitive.
So go with wildmatch().
Regards,
PS
Thank you very much