Equivalent of 'OR' function in Qlikview

[#1]

Good day,

I want to convert this piece of code to Qlikview, please assist:

CASE when TERM IN (0,NULL) then ''X''

[sinanozdemir]

Hi,

Something like this:

If(TERM = 0 or IsNull(TERM), 'X')

Hope this helps.

[petter]

You could also do this:

If( Match( TERM , 0 , Null() )  , 'X' )

[Kushal_Chawda]

try this

=if( len(trim(TERM))=0,'X') as TERM

[evan_kurowski]

FOR EACH Value in '',0,Null(),'0',' '

      Let TERM = IF(Len(Trim('$(Value)'))>0,'$(Value)',0);

      SWITCH '$(TERM)'
           CASE 0
                Trace switch trapped;
           DEFAULT
                Trace no switch;
      END SWITCH

NEXT

[#6]

Thanks everyone!!!