Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
IF(tp.Isuueflag = 'P', th.direction,
IF(tp.Isuueflag = 'T', ld.direction,
LegDirection)) as YourFieldName
IF(tp.Isuueflag = 'P', th.direction,
IF(tp.Isuueflag = 'T', ld.direction,
LegDirection)) as YourFieldName
PICK(MATCH( tp.Isuueflag, 'P' , 'T' ),th.direction, ld.direction)
IF() expression Also works as suggested by Manish above