topic One condition with more than one value in QlikView

One condition with more than one value

Sat, 17 May 2014 04:16:55 GMT

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

END

Re: One condition with more than one value

MK_QSL — Sat, 17 May 2014 06:00:55 GMT

You can use as below

IF(Match(TRAN_TYPE,'COS', 'ICO', 'ISI', 'ISS', 'IST', 'RSI', 'FAO'),TRAN_AMOUNT,0)

Re: One condition with more than one value

Joseph_Musekura — Sat, 17 May 2014 06:20:02 GMT

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;

Re: One condition with more than one value

PrashantSangle — Sat, 17 May 2014 06:35:58 GMT

Hi,

You can use wildmatch() also.

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,

Re: One condition with more than one value

Sat, 17 May 2014 07:48:08 GMT

Thank you very much