topic Re: If logic in QlikView

If logic

bhavvibudagam — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

Can any one please help me to convert the below SQL Case Statement into Qlik.

case when tp.Isuueflag = 'P' then th.direction

when tp.Isuueflag = 'T' then ld.direction

end Direction,

Thanks in advance

MK_QSL — Sat, 17 Mar 2018 09:46:13 GMT

IF(tp.Isuueflag = 'P', th.direction,

IF(tp.Isuueflag = 'T', ld.direction,

LegDirection)) as YourFieldName

Qrishna — Sat, 17 Mar 2018 10:05:11 GMT

PICK(MATCH( tp.Isuueflag, 'P' , 'T' ),th.direction, ld.direction)

IF() expression Also works as suggested by Manish above