If logic

[bhavvibudagam]

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 · Accepted solution]

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

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

LegDirection)) as YourFieldName

[Qrishna]

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

IF() expression Also  works as suggested by Manish above